#Invalid Operation

Lisi
Lisi
edited 12/09/19 in Formulas and Functions

Hello,

 

I have this formula:

=IF(AND([Completion Date]@row = "", [Date Range End]@row < TODAY()), "Past Due", "ALL DONE")

I've tried a few things but I keep getting invalid operation, and I'm sure it's something foolish and easy but I can't seem to figure it out.

 

Tahnk you-

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!