Say I want to do something like:
IF(A=B,"B",IF(A=C,"C",IF(A=D,"D","A")))
How many nested IF's can I do in a UI ONLY Forumla. Is there a limit?
IF(A=B,"B",IF(A=C,"C",IF(A=D,"D","A")))
How many nested IF's can I do in a UI ONLY Forumla. Is there a limit?
Skuidward Tentacles (Raymond), Champion
 17,510 Points
Posted 2 years ago
 474 Points
Hello Raymond,
Not sure about the limit, I have quite a few nested IF formulas that with more than 5 IFs and one that has 10+. I also have some calculations based on the result included in the nested IF formulas and haven't encountered any issues.
Would be good to know if there is a hard limit.
Cheers
Damien
Not sure about the limit, I have quite a few nested IF formulas that with more than 5 IFs and one that has 10+. I also have some calculations based on the result included in the nested IF formulas and haven't encountered any issues.
Would be good to know if there is a hard limit.
Cheers
Damien
mB Pat Vachon, Champion
 43,056 Points
 17,326 Points
I don't know of any limit. However there probably comes a point where it'll look like an actuary's SQL thread and that's not something I want to think about troubleshooting.
Skuidward Tentacles (Raymond), Champion
 17,510 Points
I’ll be testing the limits. I’ll let you know. All the if statements are identical except the comparison word so hopefully it will be easy enough to keep organized
 17,326 Points
I wish you the best Skuidward. I'll be curious to see what you find. Please keep us updated with what you find
Related Categories

Skuid on Salesforce
 2405 Conversations
 190 Followers