Smartsheet Formula Question - If statement with formulas

I currently have a Smartsheet that has a calculated date field. So for example a Requester has an entry date and then we calculate the due date field using a column formula.

The formula used to be just Requestor Entry Date @ row +3 to set it 3 days forward. However, the issue came up where entries on a Friday would show due as Monday which was shorter than expected.

I changed the column formula in the Due Date field to use =WORKDAY([Requested Date]@row, 3) which has worked for keeping it to 3 business days instead of just 3 days.

Here comes the part I'm struggling with (not great with formulas). In every form entry there is a field called Urgent which is just a drop down Yes/No.

What they would like to see happen is if Urgent = Yes, then something more like Requestor Entry Date @row +1 (for next business day) but if no, then =WORKDAY([Requested Date]@row, 3) to keep the 3 business days.

I've tried variations of this but keep getting Incorrect argument or parameter errors.

=IF([Urgent]@row, "No", (WORKDAY([Requested Date]@row, 3), [Requested Date]@row +1))

Can someone guide me on the proper syntax to make this work if possible ?

Thanks in advance.

Find more posts tagged with

Accepted answers

Gillian C

Hi @tovythomas

Try this formula

=IF(Urgent@row = "Yes", WORKDAY([Requested Date]@row, 1), WORKDAY([Requested Date]@row, 3))

It looks like you just grouped the true and false parts of your if statement.

All comments

Gillian C

Hi @tovythomas

Try this formula

=IF(Urgent@row = "Yes", WORKDAY([Requested Date]@row, 1), WORKDAY([Requested Date]@row, 3))

It looks like you just grouped the true and false parts of your if statement.

tovythomas

Thanks, I actually had just talked that over with a teammate here and he mentioned the same.

I think i got cross eyed and just kept doing the same thing. I ended up using the same thing you just did it and got i to work.

=IF(Urgent@row = "No", WORKDAY([Requested Date]@row, 3), WORKDAY([Requested Date]@row, 1))

Thank you for your 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.