How to set a column values base on the selection of another choice column? In sharepoint lists

Question

Hey,

I'd like to assign value based on choice column "CARS" to another value column "Price" so if I choose "Porsche" from my list, I want to assign a price in the column "Price".

I could not do it with calculated column, since choice column is not "allowed"

thanks.

Answer 1

Hi @Jack ,

Do you mean that the value of the "Price" column needs to be automatically filled according to the value of the Choice column "CARS"? If so, you can use a calculated column. This is my test:

1. Create a calculated column named Price and fill it with the following formula:

=IF(CARS="Choice 1","200",IF(CARS="Choice 2","400",IF(CARS="Choice 3","600","")))

You can change the value in the formula according to your actual needs.

2. When different values ​​are selected in the CARS column, the Price column will automatically fill in the corresponding value.

Good day!

---

If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Great, thank you it's working. I've created new option column, cuz my original one wasn't showing in the field "insert column".

Is there a way how to choose two options, for example choice 1 and choice 2 in one column and sum the price ?

Answer 3

Hi @Jack ,

The calculated column is used to reference the value in the column. There are too many values ​​in the multiple-select column, and the reference will be complicated, so the multiple-select column does not currently support calculated columns.

There is a workaround for your reference: put the two values ​​of the multiple-select column into two single-select columns.

Formula:

=CARS+Choice

The result:

Hope this can help.

---

If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.