IF Statement with cell either blank or with any date
Hi everyone
Please can you assist me with correcting this formula? I have a column 1st queries received that is locked to dates only. This formula is for the health status column.
If the deadline is in the future, then the health status must be blank.
If the deadline is in the past, the received date is blank, and the responded checkbox is ticked then the health status must be blank.
If the deadline is in the past, and any received date is posted, and the responded checkbox is not ticked then the health status must be Red.
=IF(AND([1st Queries Deadline]@row < TODAY(365), [1st Queries Received]@row > "", [1st Queries Responded]@row = 0), "Red", "")
Regards,
Marco de Oliveira
Best Answer
-
You cannot use a > "" operator on a date field.
Instead, try [1st Queries Received]@row <> "" or better yet NOT(ISBLANK([1st Queries Received]@row))
I hope this helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
You cannot use a > "" operator on a date field.
Instead, try [1st Queries Received]@row <> "" or better yet NOT(ISBLANK([1st Queries Received]@row))
I hope this helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Amazing, thanks. As a matter of interest, I had tried the <> "" one before and it did not work, but the NOT(ISBLANK() works perfectly.
Thanks so much.
Regards,
Marco de Oliveira
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!