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

Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…
Index Match on same sheet only matches to the first key found at top of row
The Index Match on same sheet only matches to the first key found at top of row where I am expecting it to look at all rows in the sheet. Here's the formula in Col3. =INDEX([Capacity 1]@row, MATCH([Collapsing 1]@row, Key:Key, 0)) And the example is below: You can see that the ABC12345 under Collapsing 1 col matches to the…