Formula issue

Have built this formula

I need to return a "High" symbol if my DD helper Column is greater than 10 working days, a "low" symbol if < than 10 working days and if the DD helper column is blank then return blank - but i am getting an error

DD 10 Day helper column is set with a record the date automation - when the status changes to Due Dilgence

=IF(ISBLANK([DD 10 Day - Helper Column]@row), "", IF(WORKDAY([DD 10 Day - Helper Column]@row, 10) < 10, "low", "high"))

Find more posts tagged with

Accepted answers

AndyJW

WORKDAY returns a date, i.e. 10 days after the helper column.

You need to use NETWORKDAY to get the number of days between the helper column and today.

=IF(ISBLANK([DD 10 Day - Helper Column]@row), "", IF(NETWORKDAY([DD 10 Day - Helper Column]@row, TODAY()) < 10, "low", "high"))

All comments

AndyJW

WORKDAY returns a date, i.e. 10 days after the helper column.

You need to use NETWORKDAY to get the number of days between the helper column and today.

=IF(ISBLANK([DD 10 Day - Helper Column]@row), "", IF(NETWORKDAY([DD 10 Day - Helper Column]@row, TODAY()) < 10, "low", "high"))

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.