basic formula to auto-populate one cell based on selection in another cell

Hello - Hopefully an easy question, I just have a mental block when it comes to the formulas. I have a "Location" column with six options (single select). I have another column, "Representative" that has 4 selections. I would like the Representative column to auto populate based on what is selected in the Location column.

For instance; if Portland or Seattle are selected in the Location column, then I want "Rob" to auto-populate in the Representative column. If Boise is selected I want Sarah to auto-populate.

I thought maybe IF or INDEX might be the way to go, but I keep getting the unparseable message (which is pretty standard for me and Smartsheet formulas :). Any help or examples would be greatly appreciated!

All the best,

Find more posts tagged with

Formulas

Accepted answers

Bassam Khalil

Hi @JB MacPhee

Hope you are fine, i created this sample using your criterias in your quastion and you can extend the formula as per your actual criteria and if you like you can provide all the selections on the column "Location" & "Representative" and i will create the formula for you

=IF(OR(Location@row = "Portland", Location@row = "Seattle"), "Rob", IF(Location@row = "Boise", "Sarah"))

the following screenshot shows the result:

All comments

Bassam Khalil

Hi @JB MacPhee

=IF(OR(Location@row = "Portland", Location@row = "Seattle"), "Rob", IF(Location@row = "Boise", "Sarah"))

the following screenshot shows the result:

Bassam Khalil

@JB MacPhee

Thanks for accepting my answer and am happy to help you any time.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.