Formula creation to auto-populate priority symbol
Hello,
I'm looking for help with creating a formula. I'm trying to auto-populate the "Project Heath" column (red, yellow, green symbols) based off of my "Provider Start Date" column.
If "Provider Start Date" is in 15 days or less from today, the "Project Heath" should be “red”
If "Provider Start Date" is 16 days to 34 days from today, the "Project Heath" should be “Yellow”
If "Provider Start Date" is 35 days or more from today, the "Project Heath" should be “green”
Can someone please assist with creating this formula?
Thanks in advance,
Kaitlyn
Best Answer
-
Try something like this...
=IF([Provider Start Date]@row >= TODAY(35), "Green", IF([Provider Start Date]@row >= TODAY(16), "Yellow", "Red"))
Answers
-
Try something like this...
=IF([Provider Start Date]@row >= TODAY(35), "Green", IF([Provider Start Date]@row >= TODAY(16), "Yellow", "Red"))
-
Awesome! Thank you, Paul!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!