Need help finishing formula for status
I want to Turn the status to Yellow if [Done?] is unchecked and the field [Server must be 100% Cutover to New Box by:] is less than 13 days away from today if not then green.
So this works:
=IF(AND([Done?]@row = 0, [Server must be 100% Cutover to New Box by:]@row - TODAY() < 13), "Yellow", "Green")
BUT, I want to add to the working formula that works above what is below:
if the [Done?] field is unchecked and if Today is greater than [Server must be 100% Cutover to New Box by:] field then return Red. In other words if the date the server cutover must be completed is in the past then Red.
For some reason I just can't make this last part work.
Assistance would be appreciated. Thank you.
Best Answer
-
HI @Edward Spencer,
Try this: =IF(AND(Done?@row = 0, [Server must be 100% Cutover to New Box by:]@row < TODAY()), "Red", IF(AND(Done?@row = 0, [Server must be 100% Cutover to New Box by:]@row - TODAY() < 13), "Yellow", "Green"))
Hope that helps 😊
Matthew
Answers
-
HI @Edward Spencer,
Try this: =IF(AND(Done?@row = 0, [Server must be 100% Cutover to New Box by:]@row < TODAY()), "Red", IF(AND(Done?@row = 0, [Server must be 100% Cutover to New Box by:]@row - TODAY() < 13), "Yellow", "Green"))
Hope that helps 😊
Matthew
-
Thank you, that worked perfectly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!