Forum Discussion
TPalmer1695
Mar 21, 2024Copper Contributor
Sharepoint List - Multiple IF AND function in calculated column
Hi, I'm trying to create a column that will calculate a value based on a risk matrix; I have come up with the formula below, but it's not working. I've also tried a switch formula without success. I'...
- Mar 21, 2024
TPalmer1695 You are using more than 19 nested IF functions in calculated column formula which is not supported in SharePoint Online.
You will have to break your formula with batches of 19 IF functions and combine them using &. Check these links for more information and examples:
- What is the maximum syntax formulas that I can use in calculated column on my SharePoint list?
- What is the workaround for limit in nested if statements in SharePoint calculated column?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap
Mar 21, 2024MVP
TPalmer1695 You are using more than 19 nested IF functions in calculated column formula which is not supported in SharePoint Online.
You will have to break your formula with batches of 19 IF functions and combine them using &. Check these links for more information and examples:
- What is the maximum syntax formulas that I can use in calculated column on my SharePoint list?
- What is the workaround for limit in nested if statements in SharePoint calculated column?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Betanguera8
May 20, 2024Copper Contributor
ganeshsanap I did test the workaround and it worked, however, my column now includes a FALSE statement next to each formulas response. Any idea how to fix it?