Forum Discussion

Copper Contributor

Sep 11, 2019

Solved

How to Edit a Calculated Column & IF Statement Limits?

I have a calculated column which uses the following formula =IF([_UpdatedSupplierFinancialRiskRating ]="High",15,IF([_UpdatedSupplierFinancialRiskRating ]="Medium",7,0)) I was having trouble ...

SharePoint Online

kaleyanne
Sep 11, 2019
I was able to find the answer in this video:

https://www.youtube.com/watch?v=ic9Je9AlAf4

I had to convert to the old format through to see this list settings. But it worked and that is all that matters right now. Did all of this functionality go away with the new look? I suspect not but I can't seem to find it. Needless to say I will be using the old look from now on.

Thanks!

kaleyanne

Copper Contributor

Sep 11, 2019

I was able to find the answer in this video:

https://www.youtube.com/watch?v=ic9Je9AlAf4

I had to convert to the old format through to see this list settings. But it worked and that is all that matters right now. Did all of this functionality go away with the new look? I suspect not but I can't seem to find it. Needless to say I will be using the old look from now on.

Thanks!