Rule (Formula) to Check a box if the create date is past 90 days

Tom deGroh
edited 12/09/19 in Formulas and Functions

Thanks for checking this out as my formula game is pretty weak. I am looking to have a formula that will check a box if the create date is 90 days in the past provided another box was checked.Real world I want to call out all statements of work that are older than 90 and we have not received a purchase order (PO received check box) as well, to check the SOW Abandoned box. 

I was hoping that this would work in conditional formatting but sadly no. 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!