Why would this formula return an error message?

I am using the formula to count networkdays on resolved tickets and networkdays on open tickets. Trying use the if formula, but error is returned. Any suggestions? Thank you,

=IF({Sheet - CCTV Issue Tracking with Form Range 25} = "Resolved", (NETWORKDAYS ({Sheet - CCTV Issue Tracking with Form Range 26}, {Sheet - CCTV Issue Tracking with Form Range 27})), (Networkdays ({Sheet - CCTV Issue Tracking with Form Range 26}, Today())))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

It looks like there may be a few issues. Are you able to provide some screenshots for reference and more detail as to what you are trying to accomplish?

Carey Drayton

Screen Shot 2022-03-07 at 10.01.05 AM.png

Screen Shot 2022-03-07 at 10.00.40 AM.png

I am tracking repairs of CCTV. My supervisor wants to have the Workdays a ticket is open until it is closed. When I originally created the sheet I did not have any resolved tickets. Now that I have resolved tickets and open tickets I would like to have a single formula to determine the Correct Workdays a ticket is open if resolved and then when it is still open.

Thank you for your assistance.

Paul Newcome

Try this:

=NETWORKDAYS([Issued Date]@row, IF([Ticket Status]@row = "Resolved", [Resolved Date]@row, TODAY()))

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.