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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!