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

Tom deGroh

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. 

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

=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.