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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!