ISBLANK Question
I need a qualifier to ignore blank cells in this formula:
=IF(AND([Due Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0)
Right now this is counting blank date fields as "1".
I see the ISBLANK modifier but is there a NOTBLANK argument in SS?
Best Answers
-
Hi @TSmelser
Hope you are fine, please try the following formula
=IF(AND(ISDATE([Due Date]@row), [Due Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0)
the following screenshot shows the result
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Many thanks Bassam. This works for me. Cheers!
Answers
-
Hi @TSmelser
Hope you are fine, please try the following formula
=IF(AND(ISDATE([Due Date]@row), [Due Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0)
the following screenshot shows the result
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Many thanks Bassam. This works for me. Cheers!
-
You are welcome and I will be happy to help you any time.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!