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

cool thanks, it works.

I have one more question .....how to make a sum in particular row from calculated columns and create value column called "suma". -> I can't use calculated column, cause I need to make another sum in column "Suma"

Answer 2

Hi @Jack ,

According to your latest reply, you want to sum the previously calculated column Price, right? If so, you can simply add these columns together.

This is my test:

---

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 3

Hello I tried to achieve it with power automate, but it's not working ....any ideas please?

Answer 4

Hi @Jack ,

You mean, you want to sum the suma1 in the last column, just like in the Excel file, right?

If so, unfortunately, this is not supported in SharePoint at present. The values ​​of each row in the column are equal and independent, and there is no way to calculate them. The current calculated column only supports calculations between columns.

If you want to sum, you can export the list to Excel by clicking Export-->Export to Excel, and then sum it in the Excel file.

Just like this:

---

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.