When a specific value present, calculate date from Created to Date of completion

For other sheets, we use formula

=IF(ISBLANK([Manually Actioned By]@row), NETWORKDAYS(Created@row, TODAY()), NETWORKDAYS(Created@row, [Manual Actioned Date]@row))

to tell us the turnaround time for the activity. It might not even be a great formula but it does what I need.

But now, want to only trigger this where Status@row = Failure (from several options available in dropdown). The AI generated formula's aren't working, so appreciate any help.

Find more posts tagged with

Accepted answers

Paul Newcome

The easiest way to add something like this is to just wrap the whole thing in another IF.

=IF(Status@row = "Failure", existing_formula))

All comments

Paul Newcome

The easiest way to add something like this is to just wrap the whole thing in another IF.

=IF(Status@row = "Failure", existing_formula))

LMou

Thank you!! In my frustration, I hadn't used "" which is why my previous attempts didn't work! All good now. Thanks again 🙌

Paul Newcome

Happy to help. 👍️

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.