Is there any limit to the number of nested If statements in a UI only formula field?

  • 1
  • Question
  • Updated 1 year ago
  • Answered
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?
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb

Posted 1 year ago

  • 1
Photo of Damien Murray

Damien Murray

  • 474 Points 250 badge 2x thumb
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
Photo of mB Pat Vachon

mB Pat Vachon, Champion

  • 42,764 Points 20k badge 2x thumb
Same here. No issues in an 8 nested If.
Photo of Stephen Sells

Stephen Sells, Official Rep

  • 17,160 Points 10k badge 2x thumb
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.
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
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
Photo of Stephen Sells

Stephen Sells, Official Rep

  • 17,160 Points 10k badge 2x thumb
I wish you the best Skuidward. I'll be curious to see what you find. Please keep us updated with what you find