I have a formula that works and I need to add an additional criteria to improve the use of my sheet

=IF([Intake Status]@row = "Assigned to CHC", "C" + [Intake ID (auto-generates)]@row, " ")

I need to add another selection from my Intake Status row, "Pod 2 - Health Services" so that whenever someone selects either of these two from the drop down it will auto generate a client number.

I've tried multiple formulas and the system says that I don't have the syntax quite right, that lets me know that I'm on the right path.

=IF([Intake Status]@row = "Assigned to CHC", "C", =IF([Intake Status]@row = "Pod 2 - Health Services", "C"+ [Intake ID (auto-generates)]@row, " ")))

Find more posts tagged with

Accepted answers

All comments

Christina09

Hi @Keonda ,

I think it's mainly you got the extra = in the IF formula and extra )

This should work:

=IF([Intake Status]@row = "Assigned to CHC", "C", IF([Intake Status]@row = "Pod 2 - Health Services", "C " + [Intake ID (auto-generates)]@row, " "))

Keonda

I figured it out!

=IF([Intake Status]@row = "Assigned to CHC", "C" + [Intake ID (auto-generates)]@row, IF([Intake Status]@row = "Pod 2 - Health Services", "C" + [Intake ID (auto-generates)]@row, " "))

The previous statement had an = next to the 2nd IF, and that wasn't necessary. I had an additional bracket at the end that wasn't needed either ). Learned that the number of brackets is based on the number of statements within the formula. 2 IF statements means )) at the end.

Christina09

@Keonda

Glad it worked out for you :)

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.