Rule (Formula) to Check a box if the create date is past 90 days
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
-
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!
Help Article Resources
Categories
Check out the Formula Handbook template!