Future Date and Blank Formula

CaraBart28

Hello,

I am trying to figure out why my formula is working on one sheet and not the other. The formula will return one of the four results; Future Date, Report not Received, Report Received by Deadline, Report Received after Deadline. The formula I have is working for one sheet and not another. In the screen shots provided you will see that the formula works on the CareFirst sheet but not on the Alterwood sheet and I cannot figure out why it wont work for Alterwood. I have typed the formula into Alterwood rather than doing copy paste.

=IF(TODAY() < DATE(2023, 1, 31), "Future Date", IF([January '23]@row = "", "Report not Received", IF([January '23]@row <= DATE(2023, 1, 31), "Report Received by Deadline", IF([January '23]@row > DATE(2023, 1, 31), "Report Received after Deadline"))))

Formula on CareFirst Report:

Results from Above on CareFirst report correctly working:

Formula on Alterwood Report:

Alterwood: Returns the correct response when no date is entered into the cell, however as you can see with January when there is a date entered it returns "INVALID OPERATION"

isabonita

I would double check the column type in the second sheet - is it a true DATE column? Or is it TEXT?

CaraBart28

Hi @isabonita,

I did double check to make sure that it was a true date column, I also tried just starting over with a fresh sheet and I am still having the same issue. It is really weird because it is working just fine for two other sheets.

Thank you,

Cara

isabonita

@CaraBart28 - that is odd... have you tried doing a "Save as New" from one of the sheets that is working?

Paul Newcome

If the January column is in fact a date type column, how exactly is it being populated?