Two criteria to enter text into a cell - automation not working - use formula instead
I need to have text entered into a cell based on two criteria: a cell being completed and another cell being a date in the past. I have tried automation and it's not working. Maybe because I have formulas in the cells I'm referencing?
This formula is not working:
=IF(AND([TCP Deadline]1 < TODAY(), ISBLANK[Date Completed]35) "Late", "")
Help Article Resources
Check out the Formula Handbook template!