Is there a limit of how many conditions i can...

(Deep Foundations) #1

Is there a limit of how many conditions i can have in an “IFS” statement? I want to insert 183 conditions, however, the “App Function” gives error (with no error description) after 140 conditions.

(Tony Fader) #2

@Deep_Foundations There should be no limit, so you may be hitting a bug.

However. Having so many conditions in an IFS is going to make your life difficult. There’s probably a way to simplify. For example, you may be able to use a LOOKUP expression: appsheet.com - Lookup Function - How to use the LOOKUP function

Can you post your formula (or a sketch of it, at least)? Lookup Function - How to use the LOOKUP function appsheet.com

(Deep Foundations) #3

@tony

Thanks for your prompt response. When will Appsheet be looking into this problem to fix the bug? Should i submit the bug somewhere? I just need to get this app published this month. Also, lookups wont help in my case, it is kinda complex. Thanks for the suggestion anyways.

(Aleksi Alkio) #4

Would it be possible to show the formula… not the whole one but part of it so we could try to understand is there any other way to build it.

(Tony Fader) #5

@Deep_Foundations Yes, please post your formula. It will be helpful to find the possible bug, but also I’m guessing we could figure out a dramatic simplification.