Nest IF formula

sholmes · 01/27/22

I have tried looking at the help but it doesn't provide details on creating nested IF formula.

I am trying to say:

If the column has name 1, then return statement A; if the column has name 2 then return statement B, if neither then return statement C. Any tips?

Andrée Starå · 01/28/22

Hi @sholmes

I hope you're well and safe!

Try something like this.

=
IF([Assigned AM/TAM]@row = "Sonya Prear", "Exited", IF([Assigned AM/TAM]@row = "Jonathan Cyrus", 
"Transitional", "Stabilized"))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jeff Reisman · 01/27/22

=IF(Column@row = "Name 1", "Statement A", IF(Column@row = "Name 2", "Statement B", "Statement C")

Here, color-coded, you can see that if the first IF statement evaluates to TRUE, it applies "Statement A", but if it evaluates to FALSE, only then does it consider the second IF statement. If the second IF statement evaluates to TRUE, it applies "Statement B", but if it evaluates to FALSE, it applies "Statement C".

sholmes · 01/27/22

Thanks, but I still get an error message.

Jeff Reisman · 01/27/22

https://community.smartsheet.com/discussion/comment/317676#Comment_317676

There's not much more I can do to help without more information. The structure I supplied based on what you asked for is 100% correct, as long as it is applied correctly for your given situation. Without specifics on column types, the data involved, etc, I have no way to know if something would need to be adjusted.

sholmes · 01/27/22

Hi, so the column is a person's name. I thought I would have to reference the column in brackets but I am not sure. This is how I typed in the sheet where I received an error:

=IF(Assigned AM/TAM@row = “Sonya Prear”, “Exited”, IF(Assigned AM/TAM@row = “Jonathan Cyrus”, “Transitional”, “Stabilized”))

Jeff Reisman · 01/27/22

Aha. When there are spaces in your column names, or your column name ends in a number, you do need to put them in straight brackets:

=IF([Assigned AM/TAM]@row = “Sonya Prear”, “Exited”, IF([Assigned AM/TAM]@row = “Jonathan Cyrus”, “Transitional”, “Stabilized”))

These pages and this sheet help big time with functions and formulas:

Functions List | Smartsheet Learning Center

Formula Error Messages | Smartsheet Learning Center

(3) Smartsheet Formula Examples - Smartsheet.com (If you can't access this sheet, send me your smartsheet login email, and I'll share it.)

sholmes · 01/27/22

I am still getting an error. Thanks so much, I will try the help screens you provided.

Andrée Starå · 01/28/22

Hi @sholmes

I hope you're well and safe!

Try something like this.

=
IF([Assigned AM/TAM]@row = "Sonya Prear", "Exited", IF([Assigned AM/TAM]@row = "Jonathan Cyrus", 
"Transitional", "Stabilized"))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jeff Reisman · 01/28/22

https://community.smartsheet.com/discussion/comment/317698#Comment_317698

What is the error message you are seeing?

Are you using this formula in the same sheet that contains the Assigned AM/TAM column? While the syntax and formula structure is similar, if you're trying to reference a column in another sheet there are some other steps to do, which changes some things.

sholmes · 01/28/22

I am using this formula in the same sheet.

sholmes · 01/28/22

@Andrée Starå Thanks so much, that worked!

Jeff Reisman · 01/28/22

https://community.smartsheet.com/discussion/comment/317716#Comment_317716

@Andrée Starå

Very strange, you and I supplied literally the exact same formula. The only difference is that her font must be using some weird special characters or ext-ascii or something. I just copied the text from her original supplied formula and added the brackets:

=IF([Assigned AM/TAM]@row = “Sonya Prear”, “Exited”, IF([Assigned AM/TAM]@row = “Jonathan Cyrus”, “Transitional”, “Stabilized”))

Notice the difference in the quotation marks between what she supplied above, and what you supplied here:

=IF([Assigned AM/TAM]@row = "Sonya Prear", "Exited", IF([Assigned AM/TAM]@row = "Jonathan Cyrus", "Transitional", "Stabilized"))

The formula content and structure are identical.

Andrée Starå · 01/28/22

@sholmes

Excellent!

You're more than welcome!

@sholmes & @Jeff Reisman The issue was the " ". I suspect that you used Word or similar to write the formula, and then the "" will not be correct.

Jeff Reisman · 01/28/22

“Jeff” - MS WORD 365

"Jeff" - Smartsheet Community page

@Andrée Starå That must have been it!

sholmes · 01/28/22

@Andrée Starå Thanks so much, that worked! @Jeff R thanks so much, it must have been a spacing issue.

Nest IF formula

Best Answer

Answers

Help Article Resources

Categories