IF status symbol based on cell date or blank
I'm trying to write an IF formula to return a status symbol based on if a date column in my sheet is in the past OR is blank. Smartsheet keeps telling me my syntax isn't quite wrong, and I'm having trouble seeing where I've gone wrong. Here's what my formula looks like right now.
=IF(ISBLANK([Expiration Date]@row), "Red", (TODAY() - [Expiration Date]@row > 0, "Red", IF(TODAY() - [Expiration Date]@row > -30, "Yellow", "Green")))
Best Answer
-
I have a formula that is returning a red ball if the date is blank.
=IFERROR(IF([Dispatch Date]@row <= TODAY() - 14, "Red", IF([Dispatch Date]@row <= TODAY() - 7, "Yellow", IF([Dispatch Date]@row <= TODAY(), "Green"))), "")
Hope this can helps you.
Answers
-
I have a formula that is returning a red ball if the date is blank.
=IFERROR(IF([Dispatch Date]@row <= TODAY() - 14, "Red", IF([Dispatch Date]@row <= TODAY() - 7, "Yellow", IF([Dispatch Date]@row <= TODAY(), "Green"))), "")
Hope this can helps you.
-
Thanks! That worked for changing all the blank cells to be red, and the rest of my status symbols are working great, too!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!