I have a Virtual Column, and in the App Formu...

[Green_Gorilla]

I have a Virtual Column, and in the App Formula, I want IFS() statements. These are to return values based on 3 different conditions, one of which has 3 options, the second has 3 options, and the third has 7 options.

So I used AND() to evaluate these conditions, but I need 63 IFS() statments (I think… 3 x 3 x 7) When I get to 44 IFS() statments, the formula is Valid. When I add the 45th, it is not Valid, or rather, it shows a little red cross, but no reason for failing.

Am I limited in the number of conditions in an IFS() statement?

If so, is there any other way I can arrange this?

Thanks