Need assistance with invalid operation result

James Moses

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

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!

Best,

Heather

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."