Formula to fill in cell value depending on employee

jb@59069

I have a need to have specific values populate a cell based on the Employee value entered from a form.

For example:

If Steve enters his information from the form, I need the Category cell to populate with Sales Tools.

If Jen enters her information from the form, I need the Category cell to populate with Digital Marketing.

If anyone else enters info from the form, Category cell should populate with Consulting.

I have tried IF, IF(OR, IF(OR(OR and always get UNPARSABLE error.

Please help.

Find more posts tagged with

Accepted answers

unknown

This content has been removed.

All comments

Andrée Starå

Hi Jerry,

Try something like this.

=IF(ISBLANK(Employee@row); ""; IF(Employee@row = "Steve"; "Sales Tools"; IF(Employee@row = "Jen"; "Digital Marketing"; "Consulting")))

The same version but with the below changes for your and others convenience.

=IF(ISBLANK(Employee@row), "", IF(Employee@row = "Steve", "Sales Tools", IF(Employee@row = "Jen", "Digital Marketing", "Consulting")))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."

Did that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

unknown

This content has been removed.

unknown

This content has been removed.

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.