Formula Assistance for Returning a Due Date

Hello,

I feel like I'm almost there on the formula, but can't figure out why WORKDAY is causing a #unparseable error.

Function of the formula: If urgent flag is marked on the row I want the due date to be due on the same date that was by the 'Date Created' column type.

If the flag is not marked, I want the formula to calculate the due date to be due in 2 days from when the Date Created field was generated.

Here is my current formula:

=IF(URGENT@row=1,Created@row,Created@row+WORKDAY(Created@row,2,)

I can make the formula work with just Created@row +2 as part of the false statement, but I would prefer the due date not to land on a weekend.

Thanks for reading and the assistance!

Find more posts tagged with

Formulas

Accepted answers

All comments

Genevieve P.

Hey @Zachery Taylor

Were you able to sort this out? It looks like there's just a rogue comma at the end of your WORKDAY statement that needs to be removed 🙂

Try:

=IF(URGENT@row=1, Created@row, Created@row + WORKDAY(Created@row,2))

Cheers,
Genevieve

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.