Need help with IF statement
Want to have RYGB symbol auto-populate based on following:
If Status = Complete, set to Blue
If Days Late greater than 29, set to Red
If Days Late < 15, set to Green
Otherwise set to Yellow
Answers
-
Write that into seperate IF statement then join them together.
if(status@row="Complete","Blue",else...)
if([Day Late]@row>29,"Red",else...)
if([Day Late]@row<15,"Green","Yellow")
All joined together you get:
=if(status@row="Complete","Blue",if([Day Late]@row>29,"Red",if([Day Late]@row<15,"Green","Yellow")))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!