How to change the limit of if values column based on another

%3CLINGO-SUB%20id%3D%22lingo-sub-1377002%22%20slang%3D%22en-US%22%3EHow%20to%20change%20the%20limit%20of%20if%20values%20column%20based%20on%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377002%22%20slang%3D%22en-US%22%3E%3CPRE%3E%3CSPAN%3EHi%2C%0A%0AI%20have%20a%20column%20of%20type%20Choice%2C%20in%20which%20I%20have%2021%20options%20of%20incidents.%0AAnd%20I%20have%20another%20column%20based%20on%20this%2C%20in%20which%20I%20have%20an%20IF%20formula%20for%20each%20option%20to%20be%20modified%20to%20a%20work%20area.%0A%0AHowever%2C%20I%20get%20a%20syntax%20error.%20When%20testing%20I%20have%20identified%20that%20it%20only%20allows%20me%2020%20if%20values%2C%20since%20when%20I%20add%20one%20more%20it%20marks%20the%20syntax%20error.%0A%0AThis%20is%20normal%2C%20can%20it%20be%20configured%20or%20some%20alternative%20that%20I%20could%20follow%3F%0A%0AI%20appreciate%20your%20support%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1377002%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor
Hi,

I have a column of type Choice, in which I have 21 options of incidents.
And I have another column based on this, in which I have an IF formula for each option to be modified to a work area.

However, I get a syntax error. When testing I have identified that it only allows me 20 if values, since when I add one more it marks the syntax error.

This is normal, can it be configured or some alternative that I could follow?

I appreciate your support
0 Replies