Function Assistance

Hi, I have 3x check boxes marked as "in-progress", "On-Hold", "Closed".

I want to count the days the call is open which I have done with this formular:

=IF(OR([In-Progress]@row = 1, [On-Hold]@row = 1), NETWORKDAYS([Date Of Fault]@row, TODAY()))

Now if the Closed checkbox is ticked I would like to change the days mark with "Call Completed"

I have attempted this with a IF statement at the end of the formular

=IF(OR([In-Progress]@row = 1, [On-Hold]@row = 1), NETWORKDAYS([Date Of Fault]@row, TODAY())) IF(Closed@row = 0, "Call Completed", "ERROR"))

If I run a formula from the Closed Checkbox instead:

=IF(Closed@row = 0, [Days Open]@row = "Call Completed", "ERROR")

I get a Circular ref error on the Closed Checkbox

Can anyone assist.

Find more posts tagged with

Accepted answers

Paul Newcome

Try this:

=IF(OR([In-Progress]@row = 1, [On-Hold]@row = 1), NETWORKDAYS([Date Of Fault]@row, TODAY()), IF(Closed@row = 1, "Call Completed", "ERROR"))

All comments

Paul Newcome

Are you able to provide some screenshots for context?

Hargreaves

Paul Newcome

Try this:

=IF(OR([In-Progress]@row = 1, [On-Hold]@row = 1), NETWORKDAYS([Date Of Fault]@row, TODAY()), IF(Closed@row = 1, "Call Completed", "ERROR"))

Hargreaves

Paul Newcome

Do you have a screenshot of the formula open as if you are abut to edit it?

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.