Two criteria to enter text into a cell - automation not working - use formula instead

Chelsea Duncan

Hi!

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", "")

Jason Duryea

Your formula is missing a ( and comma

=IF(AND([TCP Deadline]1 < TODAY(), ISBLANK([Date Completed]35), "Late", "")

Jason Duryea

Your formula is missing a ( and comma

=IF(AND([TCP Deadline]1 < TODAY(), ISBLANK([Date Completed]35), "Late", "")

Chelsea Duncan

awesome! thank you :)