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

  • Whelandon
    Whelandon ✭✭✭

    hmmm, I don't have time to parse the whole thing out, but you want your formula to be in the checkbox column, and you want it to check two things and return a "1" (which will check the box) if both conditions are met. So it will be something like =IF(AND(TODAY()-90>=SOW, [PO Received] = 1), 1).

    Something like that. it might be <=. I'm not the greatest with formulas but I fake it until I make it and somehow they end up working. When you get in there and start typing the formula it should come to you. good luck!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    =IF(AND(TODAY(-90) > [Date Column Name]@row, [PO Checkbox Column Name]@row = 0), 1)

     

    Give this a try. Just change the column names to whatever you need.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!