Formula for status color

Lauren Strang

Hello, I am looking for the right formula to make the Status color change. My goal is to have the color change based on the days since updated. So the status will be green 0-179 days. Then Yellow when the days since updated is 180+ days, and turn Red if it's 360+ days.

James Keuning

=IF((TODAY() - [last updated]@row) < 180, "G", IF((TODAY() - [last updated]@row) < 360, "Y", IF((TODAY() - [last updated]@row) >= 360, "R")))

James Keuning

=IF((TODAY() - [last updated]@row) < 180, "G", IF((TODAY() - [last updated]@row) < 360, "Y", IF((TODAY() - [last updated]@row) >= 360, "R")))

Lauren Strang

Thank you so much for help James!

Lauren Strang

@James Keuning One problem is that is it not changing the status color. Any advice?

Genevieve P.

Hi @Lauren Strang

For formulas with Symbols, you'll want to specify the specific Symbol Name in "these" in your formula.

Ex. instead of "G", type "Green".

This Help Article shows the text needed for each symbol: Available Symbols in the Symbols Column

Cheers!

Genevieve