Result from NETDAYS formula is a (-) value instead of positive value

I created this formula (with the Communities help, thank you) , the result of the NETDAY looks correct but I am getting a "-" in the number column. Is this a placement issue with the NETDAY function?

I tested the function in a separate sheet and it works properly I get the correct count and value (28):

=IF(OR(CONTAINS("Stage 1", Function@row), CONTAINS("Stage 2", Function@row)), NETDAYS([Date Date]@row, TODAY()))

When I inserted and modified the string to reflect the columns in my Production sheet I get a result but with a '-' in front of the number (-28)

=IF(OR(CONTAINS("Stage 1", Stage@row), CONTAINS("Stage 2", Stage@row)), NETDAYS([Close Date:]@row, TODAY()))

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @Rick Girard

I answered this in your other post.

https://community.smartsheet.com/discussion/94767/using-the-or-function-to-select-a-fixed-value-in-a-cell-that-contains-specific-characters#latest

Did it work for you?

Kelly

Rick Girard

I'll be checking it later today, thank you for your fast reply Kelly!

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.