Two criteria to enter text into a cell - automation not working - use formula instead
Options
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", "")
Best Answer
-
Your formula is missing a ( and comma
=IF(AND([TCP Deadline]1 < TODAY(), ISBLANK([Date Completed]35), "Late", "")
Answers
-
Your formula is missing a ( and comma
=IF(AND([TCP Deadline]1 < TODAY(), ISBLANK([Date Completed]35), "Late", "")
-
awesome! thank you :)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!