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)

Find more posts tagged with

Formulas

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.