Tried searching, but I couldn’t find anything that answered my question. I believe my formula is correct, and it doesn’t throw an error, however, every time I input it from Notepad ++ it limits it.
Basically I’m trying to assign point values if certain criteria are selected from a multi-select form. I was able to convert it to a stringify data.
So there are nine options.
Option 1, Option 2, and Option 3 are selected. 15 points
Option 1, Option 4, and Option 7 are selected. 10 points
Option 6 and Option 7 are selected. 5 points
Option 9 is selected 0 points.
I’m okay with doing multiple, nested IF formulas, but again it limits it? Any reason why?