Update formula so it ignores empty rows
Hello. I am using the below formula to mark whether a task is overdue or not, and then highlight using conditional formatting those overdue tasks in red:
=IF(AND(Finish@row < TODAY(), Status@row <> "Complete"), "true", "false")
I would like to update the formula to ignore blank rows. How may I accomplish this?
Also, open to broader suggestions how to better accomplish this same goal. Thank you!
Tags:
Answers
-
Something like this at the beginning perhaps?
=IF(Finish@row="","",
The double quotes "" populate a blank if there's a blank found, thus ignoring the them in your formula results.
-
=IF(Finish@row,"","",IF(AND(Finish@row < TODAY(), Status@row <> "Complete"), "true", "false"))
...
-
Thank you for the responses! I get "INCORRECT ARGUMENT" with the above solution @Mr. Chris / @heyjay
-
=IF(Status@row = "", "", IF(AND(Finish@row < TODAY(), Status@row <> "Complete"), "true", "false"))
I was missing an equal sign
...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!