When I am typing in a formula, it all goes in fine until I type the endif, then I get the red squiggly error symbol under the =. It goes bad as I type the last letter f. Everything is meant to be V_String. See screenshots below:
Solved! Go to Solution.
Please ignore, user error. The Region field was Boolean, should've been V String. Apologies.
One way to avoid this in the future is to use either the Field Info tool, Select tool, or even the Auto-Field tool to see your data types - then you won't run into this again @ppatane
@caltang Grazie! Will do.
Any suggestions as to why this formula is not working - tried several different ways. Thank you
If ([Role] = "PCP" or [Role] = "BOTH") and
([Specialty] ="General Practice” Then "Role match"
ElseIF
[Specialty] = “Family Practice” Then "Role match"
ElseIF
[Specialty] = “Geriatric Medicine/Family Prac” Then "Role match"
ElseIF
[Specialty] = “Internal Medicine” Then "Role match"
ElseIF
[Specialty] = “Geriatric Medicine/Internal Me” Then "Role match"
ElseIF
[Specialty] = “Adolescent Medicine” Then "Role match"
ElseIF
[Specialty] = "Pediatrics” Then "Role match"
ElseIF
[Specialty] = “Pediatric Internal Medicine” Then "Role match"
ElseIF
[Specialty] = “Obstetrics & Gynecology – CA P” Then "Role match"
ElseIF
[Specialty] = “General Practice - Dental”)
Else "Role MisMatch"
ENDIF
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |