I am trying to complete this command (this would be a cell value on sheet 2): A1 (sheet 1) if K(sheet 1) is current date
Basically I want cells on sheet 2 to contain data from sheet one, only if Col K on sheet one has the current date.
Is there an actual formula to complete this action?
EDIT for claification: I want to get all items on sheet 1 with the current date in column K to report to sheet 2 as a daily report. I made the error of referencing cell A1. That was just the starting point. Basically if it is on sheet 1 with the current date, it will move that line to sheet 2 as a consolideted report with no lines skipped for the lines that do not have the current date.
Basically how do I get sheet 2 to not display "false" results.
false
: Put the else-part of theIF()
back in. It's basicallyIF(condition ; then ; else)
. Since you want it to not showfalse
IF the date is different
, put what you want it to show in the else-part. That should be, well,""
as in an empty string.