If a certain drop down is selected, how do I auto populate an Inform column with the name assigned

I tried using a helper column with names in it that I intended to hide. So if the Escalation Type column allows Care Concern that Cori works on and Bluetooth Activation Issues that Marla works on- how do I get the Inform column to auto populate to Cori or Marla's name? I tried =IF([Escalation Type]="Care Concern",[Helper Column]@row),IF([Escalation Type]="Bluetooth Activation Issue",[Helper Column]2),IF([Escalation Type]="Unknown Activation Issue",[Helper Column]3),IF([Escalation Type]="Truck Roll Credit",[Helper Column]4),IF([Escalation Type]="Missing Modem",[Helper Column]5),IF([Escalation Type]="Other",[Helper Column]6)) but I get unparseable. What am I doing wrong?

Find more posts tagged with

Accepted answers

All comments

reece.buckner

Corin, I'm not sure if this would work for you, but we can resolve this without the Helper Column.

=IF([Escalation Type]@row = "Care Concern", "Cori Jensen", IF([Escalation Type]@row = "Bluetooth Activation Issue", "Marla Mitchell", IF([Escalation Type]@row = "Unknown Activation Issue", "Kim Smith", IF([Escalation Type]@row = "Truck Roll Credit", "Bob the Builder", IF([Escalation Type]@row = "Missing Modem", "Elmo", IF([Escalation Type]@row = "Other", "Paw Patrol", ""))))))

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.