Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Nested IF Statement Limit?

KJT

KJT ✭

09/22/17 edited 12/09/19 in Archived 2017 Posts

Is there a limit to the number of nested IF statements in a formula?

Tags:

Formulas

0 ·

Comments

Shaine Greenwood Employee

09/25/17

Hi KJT,

There is a 4000 character cell limit, so as long as the function fits within that character limit, you can continuously nest IF statements.

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Search a string and return multiple results
Hi experts, I have a formula that searches a string for a keywords, in a string that may include more than one result. It only returns the first instance found. Is it possible to have it continue searching and return all found keywords? Here is what I have currently…. I am looking at JOIN(COLLECT, but not clear how to…
Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
Multiple Users in Grid
Hello. I am trying to create a tracker where there will be multiple users in a Grid sheet and everyone will be adding in a new line at random and same times. Is there a way I can create it where people's work won't save on top each other? Or is there a live view on Smartsheet where other people can see that someone else is…