Netdays Formula

2025-09-30 16_37_41-(99+) RCA Tracker - Smartsheet.jpg

I am wanting to calculate Netdays but only if there is data in 'Corrective Action 1'

I am currently using this formula:

=IF(ISBLANK([Date Action 1 Complete]@row ), NETDAYS([Date of Event]@row , TODAY()), NETDAYS([Date of Event]@row , [Date Action 1 Complete]@row ))

How do I adjust it to only pull a date when Corrective Action 1 is not blank?

Thank you in advance!

Find more posts tagged with

Formulas

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @Amber N

=IF(
  ISBLANK([Corrective Action 1]@row), 
    "", 
    IF(
      ISBLANK([Date Action 1 Complete]@row), 
        NETDAYS([Date of Event]@row, TODAY()), 
        NETDAYS([Date of Event]@row, [Date Action 1 Complete]@row)
  ))

https://app.smartsheet.com/b/publish?EQBCT=b3fa0adad3b24f7ab614a657aafdf732

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.