Multiple Functions per Cell/Column

Hi,

Is it possible for a single Cell/Column to have multiple functions and if so, how do you achieve it?

For reference, I am trying to track the amount of days between different date columns, however it might take a few hours/days to input the second date. Because of this the cell is filled with #Invalad Data Type.

Is there a way to combine =NETDAYS ([Ordered Date]@row, [Received Date]@row) *formula used to track the number of days* with =IFERROR(Ordered Date]@row - [Received Date]@row) *formula used to stop the #Invalad Data Type from showing*?

Any information would be helpful. Thank you!

Find more posts tagged with

Formulas

functionality

Accepted answers

Sameer Karkhanis

You have to nest the formula. See below,

IFERROR(NETDAYS ([Ordered Date]@row, [Received Date]@row), "")

All comments

Sameer Karkhanis

You have to nest the formula. See below,

IFERROR(NETDAYS ([Ordered Date]@row, [Received Date]@row), "")

nlarson_PMC

Thank you @Sameer Karkhanis!

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.