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
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 150 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 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!