Formula for using RYGB with certain criteria
Hi All,
Hope you guys can help me out. I'm trying to set up a formula where it looks at 2 dates and a checkbox and return certain outputs based on whats filled in.
So the main outputs should be:
- If Date 1 is empty and checkbox is empty = Blue
- If Date 1 is empty but checkbox is checked = Green
- If Date 1 is filled and checkbox is checked = Green
- If Date 1 is within 3 weeks of Date 2 and Checkbox isnt checked =Yellow
- If Date 1 isn't within 3 weeks of Date 2 and Checkbox isnt checked = Blue
- If Date 1 is within 2 weeks of Date 2 and Checkbox isnt checked = Red
Hope you guys can help me out!
Tags:
Answers
-
Hey @Jeffrey Wagemans ,
Do you want the words "Blue", "Yellow"... to appear or do you want to use Conditional Formattion to color the row or cell?
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 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!