# Status Ball change 30 days after start date

Options
✭✭✭✭

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:

• ✭✭✭✭✭
Options

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!
• ✭✭✭✭
Options

Hi,

That gave me 30 days is green, 60 days is yellow more than 60 is red.

• ✭✭✭✭✭✭
Options

Try this:

=IF([RFT Start Date]@row<= TODAY(-60), "Red", IF([RFT Start Date]@row<= TODAY(-30), "Yellow", "Green"))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!