Trying to return a value using if and statements but get Unparseable so Help?

Saradinen ✭✭
edited 04/25/23 in Formulas and Functions

=IF(AND([Due date 2023]@row > TODAY(), ISBLANK[Completed 2023]@row), "yes", BLANK)

This is the formula which I think is pretty simple but I'm trying to get a yes if the date from due date column is greater than today and information has not been submitted in the completed column.

Feedback is appreciated


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!