Need assistance with invalid operation result

For the below once I have a date in [In Progress Date] or [Actual Completion Date] it sets #Invalid Operation when I expect a date result.

=IF([Actual Completion Date]@row = 0, IF([In Progress Date]@row <> 0, [In Progress Date]@row + ([Estimated Days to Completion]@row * [Resource Time Percentage]@row), "TBD"), [Actual Completion Date]@row)



  • Heather Duff
    Heather Duff ✭✭✭✭✭✭

    Hi James,

    It looks like you're missing a result for the first IF statement. (If actual completion date = 0, what will happen?) If you provide screenshots with sensitive information blacked out or describe what you're trying to do with the formula, we may be able to dig a bit deeper.

    Hope this helps!



  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭

    Hi, James. Is the column where you are using this formula formatted as a Date type column? That's the most common reason for the #INVALID OPERATION error.

    I'm also unsure about two other parts of your formula, though. If [Actual Completion Date] is a date field, your IF statement testing for "=0" is going to trigger an #INVALID OPERATION error, too. Same problem with [In Progress Date] testing for "<>0."

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!