Future Date and Blank Formula
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"
Answers
-
I would double check the column type in the second sheet - is it a true DATE column? Or is it TEXT?
-
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
-
@CaraBart28 - that is odd... have you tried doing a "Save as New" from one of the sheets that is working?
-
If the January column is in fact a date type column, how exactly is it being populated?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!