Status Ball change 30 days after start date
Krista Coffman
✭✭✭✭
Hello!
I am assisting a colleague with a smartsheet issue. She would like the status ball to become yellow when 30 days have past the RFT start date and red when 60 days have past the RFT start date. I can't seem to figure it out and I thought I'd see if anyone can help while I continue to try and figure this out. Thanks in advance!
Tags:
Answers
-
Hi,
You can try:
=IF(TODAY() - [RFT Start Date]@row >= 60, "Red", IF(TODAY() - [RFT Start Date]@row >= 30, "Yellow", "Green"))
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
-
Hi,
That gave me 30 days is green, 60 days is yellow more than 60 is red.
-
Try this:
=IF([RFT Start Date]@row<= TODAY(-60), "Red", IF([RFT Start Date]@row<= TODAY(-30), "Yellow", "Green"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K 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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!