Need help with multiple If formula

Hello - I am having trouble converting an excel Ifs formula into smartsheet. I am able to get a single If formula to work, but cannot link them to each other - or even know if it is possible. Full disclosure, I am not very familiar with more advanced formulas.

I have a column that has multiple entries. I created another column to rename the entries for sorting purposes (as an aside, I couldn't just rename the original column because it is linked to many other sheets/dashboards).

If the cell is named Pre-Qualify, I want it to be 00.Pre-Qualify in the new column; if it's named Cover the Bases, then it should be 01. Cover the Bases, etc. Below is what I've used on a single cell and it works. How do I link them together for one large formula? I've tried to use AND or OR and other several things and it either comes out Unparseable or Incorrect Argument. I've added the Logical Expression 2 as "blank" and it will again work on the singular formula, but not if I try to link them.

Example using IF/OR:

=IF(OR(Stage@row = "Cover the Bases", "01.Cover the Bases", IF(OR(Stage@row = "Pre-Qualify", "00.Pre-Qualify"))))

Single formulas that work are below.

=IF(Stage@row  = "Pre-Qualify”, "00.Pre-Qualify")

=IF(Stage@row  = "Cover the Bases”, "01.Cover the Bases")

=IF(Stage@row = "Pipeline", "02.Pipeline")

=IF(Stage@row  = "Pending”, "03.Pending")

Any help is appreciated. Thank you!

Tags:

Best Answer

  • Rick Olsen
    Rick Olsen ✭✭✭✭
    Answer ✓

    A nested IF seems like something that would work for this...

    =IF(Stage@row = "Pre-Qualify”, "00.Pre-Qualify", IF(Stage@row  = "Cover the Bases”, "01.Cover the Bases", IF(Stage@row = "Pipeline", "02.Pipeline", IF(Stage@row  = "Pending”, "03.Pending"))))

    The basic format is if(logical_expression, value_if_true, value_if_false). Basically, you would be asking if the first item is true. If it's false, fall to the next. This will work for what you are asking.

Answers

  • Rick Olsen
    Rick Olsen ✭✭✭✭
    Answer ✓

    A nested IF seems like something that would work for this...

    =IF(Stage@row = "Pre-Qualify”, "00.Pre-Qualify", IF(Stage@row  = "Cover the Bases”, "01.Cover the Bases", IF(Stage@row = "Pipeline", "02.Pipeline", IF(Stage@row  = "Pending”, "03.Pending"))))

    The basic format is if(logical_expression, value_if_true, value_if_false). Basically, you would be asking if the first item is true. If it's false, fall to the next. This will work for what you are asking.

  • Katyod
    Katyod ✭✭

    Thank you! I swear I was trying that, but it wasn't working :) Thanks so much - I appreciate it!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!