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.