I have a formula that works and I need to add an additional criteria to improve the use of my sheet

=IF([Intake Status]@row = "Assigned to CHC", "C" + [Intake ID (auto-generates)]@row, " ")

I need to add another selection from my Intake Status row, "Pod 2 - Health Services" so that whenever someone selects either of these two from the drop down it will auto generate a client number.

I've tried multiple formulas and the system says that I don't have the syntax quite right, that lets me know that I'm on the right path.

=IF([Intake Status]@row = "Assigned to CHC", "C", =IF([Intake Status]@row = "Pod 2 - Health Services", "C"+ [Intake ID (auto-generates)]@row, " ")))

Answers

  • Christina09
    Christina09 ✭✭✭✭✭✭

    Hi @Keonda ,

    I think it's mainly you got the extra = in the IF formula and extra )

    This should work:

    =IF([Intake Status]@row = "Assigned to CHC", "C", IF([Intake Status]@row = "Pod 2 - Health Services", "C " + [Intake ID (auto-generates)]@row, " "))

  • Keonda
    Keonda ✭✭

    I figured it out!

    =IF([Intake Status]@row = "Assigned to CHC", "C" + [Intake ID (auto-generates)]@row, IF([Intake Status]@row = "Pod 2 - Health Services", "C" + [Intake ID (auto-generates)]@row, " "))

    The previous statement had an = next to the 2nd IF, and that wasn't necessary. I had an additional bracket at the end that wasn't needed either ). Learned that the number of brackets is based on the number of statements within the formula. 2 IF statements means )) at the end.

  • Christina09
    Christina09 ✭✭✭✭✭✭

    @Keonda

    Glad it worked out for you :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!