formula for status within last 365 days

Tammy Luther

I am trying to figure out a formula to use the status (red, green dots) to show if the document is within the last 365 days based on a last revision column.

Trying to track program document review. So if the last review column is within 365 then a green dot, if greater than a red dot.

Hope this makes sense.

Any help would be appreciated. THANKS

Mark Cronk

Hi @Tammy Luther ,

Set up your column as a3 color ball symbol. Enter this formula:

=IF(today()<DATEONLY([modified]@row) +365, "green", "red")

Work for you?

Mark

Tammy Luther

worked perfect - TY

Mark Cronk

Hi @Tammy Luther ,

Set up your column as a3 color ball symbol. Enter this formula:

=IF(today()<DATEONLY([modified]@row) +365, "green", "red")

Work for you?

Mark

Tammy Luther

worked perfect - TY