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!

J Tech

Hi,

You can try:

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

Krista Coffman

Hi,

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

Paul Newcome

Try this:

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