IF function help

Tom11
New Member

Hello, Sorry to bother the experts with my remedial questions, but I’m struggling with what I think is a simple issue.

I have a column, WarrantOtherJurisdiction that is a simple Enum field type with “YES” or “NO” possible responses. I have set the initial value of the column to be “NO”, as this is a situation that almost never happens. The next column, WarrantJurisdiction is also a Enum field type and list all of the counties in the State of Illinois with the addition of “None” and “IDJJ Parole”.

If WarrantOtherJurisdiction = “NO”, then WarrantJurisdiction should = “None”. If WarrantOtherJurisdication = “YES”, then the user should be able to select one of the Counties in the WarrantJurisdiction list. My expression,

If([WarrantOtherJurisdiction]=“NO”,None," ") within App formula

works correctly to indication “None” when WarrantOtherJurisdiction = “NO”, but does not allow the user to select from the list when WarrantOtherJurisdiction = “YES”. Your assistance is much appreciated!

Thank you!

0 5 164
5 REPLIES 5
Top Labels in this Space