If, And, Star Help
Hi SS Community!
I wrote a formula that is not intending as I wanted it to.
Looking for some help.
Here is my formula:
=IF(AND(ISBLANK([Entered in WD]@row), TODAY() > [Assigned To OSU]@row + 4), 1, 0
Here are my sheet columns:
I want to STAR if a PEP was assigned to the OSU but not entered in WD after five days of it being assigned.
Where did I go wrong? Right now it is throwing the star on all blanks...
Help Article Resources
Check out the Formula Handbook template!