Formula help please

I just can't get this to work. The first part of the formula works, but I having difficulty getting it to return a different option

First Part =IF(Urgency@row = "High", [Date Issued]@row + 3)

=IF(Urgency@row="High"(), [Date Issued]@row + 3), IF(Urgency@row = "Medium"(),[Date Issued]@row +7), IF(Urgency@row = "Low"(),[Date Issued]@row +14)))

I'm almost sure it's something to do with the brackets. Any help would be great

Tha;nks Jo

Find more posts tagged with

Accepted answers

Dan W

Here you go.

=IF(Urgency@row = "High", [Date Issued]@row + 3, IF(Urgency@row = "Medium", [Date Issued]@row + 7, IF(Urgency@row = "Low", [Date Issued]@row + 14)))

You were close, the extra () after "High"/"Medium"/"Low" should be removed and the closing ) after your If statements should be at the very end.

All comments

Dan W

Here you go.

=IF(Urgency@row = "High", [Date Issued]@row + 3, IF(Urgency@row = "Medium", [Date Issued]@row + 7, IF(Urgency@row = "Low", [Date Issued]@row + 14)))

You were close, the extra () after "High"/"Medium"/"Low" should be removed and the closing ) after your If statements should be at the very end.

Jo Pearson

Thank you so much Dan.

Dan W

You are welcome! Glad I could 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.