Reusing a formula, but it's not working. I need to calculate deviation on End date.

=IFERROR(IF([End Date (Projected/Actual)]@row = [Target End Date]@row , 0, IF([End Date (Projected/Actual)]@row > [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row , [Target End Date]@row ) + 1, IF([End Date (Projected/Actual)]@row < [Target End Date]@row , NETWORKDAYS([End Date (Projected/Actual)]@row , [Target End Date]@row ) - 1))))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

How exactly is it not working? Are you getting an error message or an unexpected number?

aleja

I am getting an #INCORRECTARGUMENTSET error. As I said I have used the formula in another Smartsheet without issues.

Paul Newcome

Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it?

aleja

Here it is.

Paul Newcome

Ok. Have you ensure both columns are set as date type columns? If so, how are each of the columns being populated?

aleja

One is set as Date/Time and the other one as Date only. I'd look into everything but that.

Paul Newcome

How is the Date/Time column populated? Is it manual entry or a system column? If manual entry, that is only a string that looks like a date/time. You would need to use a helper column to extract the date portion and output it as date type data.

aleja

It is a manual entry. I'll try adding a new column to pull the date. Thanks!

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.