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

Options

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,

JB

Tags:

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓
    Options

    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:


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓
    Options

    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:


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    @JB MacPhee

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

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!