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

Keonda

=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, " ")))

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

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

@Keonda

Glad it worked out for you :)