Multiple if statements

I want to change the name of a task depending on the status of an approval request.

IF ([Assigned To approval]8 is either blank or "Submitted" I want the task name to say "Attach Document Here"

IF ([Assigned To approval]8 is accepted, I want the task name to say "Invitation: Review Document"

IF ([Assigned To approval]8 , I want the task name to say "Invitation Declined"

I had this working when i only had two conditions, but cant get it to work with one function for all the above.

=IF([Assigned To approval]8 = "Approved", "Invitation: Document for Review", IF([Assigned To approval]8 = Declined, "Invitation Declined"), IF([Assigned To approval]8 = "Submitted", ="Attach Document Here", IF([Assigned To approval]8 = "", = "Attach Document Here")))

Find more posts tagged with

Accepted answers

All comments

Connor Hartford

Hi Jennifer,

It looks like you have too many, and not enough closed parentheses.

Try this:

=IF([Assigned To approval]8 = "Approved", "Invitation: Document for Review", IF([Assigned To approval]8 = "Declined", "Invitation Declined", IF([Assigned To approval]8 = "Submitted", "Attach Document Here", IF([Assigned To approval]8 = "", ="Attach Document Here"))))

You can also use this:

=IF([Assigned To approval]@row = "Approved", "Invitation: Document for Review", IF([Assigned To approval]@row = "Declined", "Invitation Declined", IF([Assigned To approval]@row = "Submitted", "Attach Document Here", IF([Assigned To approval]@row = "", ="Attach Document Here"))))

Connor

Jennifer Flanagan

I tried the first formula, but when [Assigned To Approval] is blank, it says #UNPARSABLE. The first 3 if condition works - just not the blank one.

David Joyeuse

I would rather use this one, as your "attach document here" is triggered when it's either submitted or blank:

=IF([Assigned To approval]@row = "Approved", "Invitation: Document for Review", IF([Assigned To approval]@row = "Declined", "Invitation Declined","Attach Document Here"))

If it's approved ==> Document for review.

If it's not ==> If it's declined ==> Invitation declined.

==> Submitted or Blank (or every other case) ==> Attach document here.

Hope it helped!

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.