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.

Unknown

This content has been removed.

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.