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
 18,336 Points
Posted 2 years ago
 494 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
Pat Vachon, Champion
 45,310 Points
Stephen Sells, Alum
 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
 18,336 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
Stephen Sells, Alum
 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
 2745 Conversations
 225 Followers