Using IF

Can you please suggest what is wrong with this formula? (Priority Level and Modified are both columns. Priority Level is a dropdown, Modified is the automated modified date.

=IF([Priority Level]@row, ="High: Within 2 business days", (Modified)@row)

I am eventually trying to get the formula to add 2 days to the modified date if level is high, 5 days if "Medium," etc. Thank you!

Find more posts tagged with

Community Platform

Accepted answers

Carson Penticuff

An extra comma and some extra parens:

=IF([Priority Level]@row ="High: Within 2 business days", Modified@row)

If the actual name of the Modified column DOES have the open and close parens, you will need to enclose it in square braces. [(Modified)]@row

All comments

Carson Penticuff

An extra comma and some extra parens:

=IF([Priority Level]@row ="High: Within 2 business days", Modified@row)

If the actual name of the Modified column DOES have the open and close parens, you will need to enclose it in square braces. [(Modified)]@row

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.