Question on an IF statement formula
Hello!
I would like to create a formula that makes a status column be either red, yellow, or green (using the symbols) and the rules read like this:
IF the due date is in the past AND the paid column is no, then show red in the status column
IF the due date is within the next 5 days, and the paid column is no, then show yellow in the status column
IF the due date is greater than 5 days out, and the paid column is no, then show green in the status column
If the paid column shows yes, then show gray in the status column
Thank you!!
Best Answer
-
Try something like this...
=IF(Paid@row = "Yes", "Gray", IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row <= TODAY(5), "Yellow", "Green")))
Answers
-
Try something like this...
=IF(Paid@row = "Yes", "Gray", IF([Due Date]@row < TODAY(), "Red", IF([Due Date]@row <= TODAY(5), "Yellow", "Green")))
-
That worked great - thanks Paul!
-
Happy to help. 👍️
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
Check out the Formula Handbook template!