Skip to main content

Is there a maximum number of IF statements I can nest?


1 comment

  • Tiffanie Staver
    Alex commented  ·  

    Hi Justin,

    While there is not a definite limit to the number of if() statements that can be nested, there is a limit to the size of the query that is generated by the formula. Briefly scanning over the attached formula, there is one function that is not supported by TrackVia: IFERROR. This function would need to be removed or modified in order for the table to save. 

    Additionally, the formula as a whole looks to be too large and would hit the query limit. We recommend submitting a ticket through your account to support so that we may better understand what the purpose of the formula would be. This would also allow us to better understand the use case and provide specific recommendations for a scalable solution.




Please sign in to leave a comment.

Powered by Zendesk