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
-
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, " "))
-
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.
-
Glad it worked out for you :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!