Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Formula using the RYG status balls
I'm trying to write a formula using the RYG status balls.
These are the criteria:
Green= If the "Deployment Complete" box is checked
Yellow= if there is a date populated in "Module Go-Live Date"
Blue= for anything else (deployment is not complete and Go-Live is not scheduled)
I only got this far with the formula and (of course!) it doesn't work.
=IF([Deployment Complete],1, "Green", IF([Module Go-Live Date]@row, "", "Blue")
Thanks for your help!
Best Answer
-
How about this:
=IF([Deployment complete]@row = 1, "Green", IF([Module Go-Live Date]@row <> "", "Yellow", "Blue"))
This assumes you won't have a case where both Deployment complete and Module Go-Live date are both completed (eg you have an automation that clears the value in Module Go-Live date when Deployment complete is ticked)... if there's a risk of both being ticked, you might want to add a further check in!
Rich
Rich Coles
Prodactive | Smartsheet-aligned Platinum partners
Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration
Answers
-
Greetings @deb_63_hydracor
Please give this a try:
=IF([Deployment Complete]@row = 1, "Green", IF(ISDATE([Module Go-Live Date]@row), "Yellow", "Blue"))
Please let me know if you have any issues.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
-
How about this:
=IF([Deployment complete]@row = 1, "Green", IF([Module Go-Live Date]@row <> "", "Yellow", "Blue"))
This assumes you won't have a case where both Deployment complete and Module Go-Live date are both completed (eg you have an automation that clears the value in Module Go-Live date when Deployment complete is ticked)... if there's a risk of both being ticked, you might want to add a further check in!
Rich
Rich Coles
Prodactive | Smartsheet-aligned Platinum partners
Check out our Smartsheet-dedicated YouTube channel for tips, tricks and inspiration
-
Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I have been trying to genrate a formula to shorten company names: 1- For multi word names, extract the first letter of each word, skipping over short words like "and", "the", etc. 2- For single word n…
- I am trying to calculate days open between the request date and today and not count weekends however I want the count to start at 0, not 1. I am using the below formula but for everything with today a…
- Good afternoon, I am used to INDEX/MATCH but this time I need to match two columns and then pull the information in a third column. Here is where I currently am: =INDEX(COLLECT({Meeting Planner}, {Mee…