If, then Formulas
Hi there! I am trying to create a formula for the following scenario and i've been unable to figure it out
If Status Column is "Complete", Mark as Green, IF Status of Column is NOT Complete, then apply the formula
=IF([End Date]@row < TODAY(5), "Red", IF([End Date]@row = TODAY(5), "Yellow", IF(AND([End Date]@row > TODAY(5), [End Date]@row < TODAY(30)), "Blue", IF([End Date]@row >= TODAY(30), "Green"))))
I cant figure out how to add the first part to the already working last part
Thank you!
Best Answer
-
Hi Megan! Do you mean you want to use your formula only if status is not complete?
Like this: =IF(Status@row = "Complete", "Green", IF([End Date]@row < TODAY(5), "Red", IF([End Date]@row = TODAY(5), "Yellow", IF(AND([End Date]@row > TODAY(5), [End Date]@row < TODAY(30)), "Blue", IF([End Date]@row >= TODAY(30), "Green")))))
Is that what you mean?
Answers
-
Hi Megan! Do you mean you want to use your formula only if status is not complete?
Like this: =IF(Status@row = "Complete", "Green", IF([End Date]@row < TODAY(5), "Red", IF([End Date]@row = TODAY(5), "Yellow", IF(AND([End Date]@row > TODAY(5), [End Date]@row < TODAY(30)), "Blue", IF([End Date]@row >= TODAY(30), "Green")))))
Is that what you mean?
-
Adam Murphy - YES this worked thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!