# Formula for status color

Options

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.

• ✭✭✭✭✭
Options

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

• ✭✭✭✭✭
Options

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

• Options

Thank you so much for help James!

• Options

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

• Employee
Options

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