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,224 Points
Posted 1 year 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
 42,764 Points
Stephen Sells, Official Rep
 17,160 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,224 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, Official Rep
 17,160 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
 2189 Conversations
 171 Followers