formula for status within last 365 days


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

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!