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. 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!