Why isn't this expression working?

[djmalaka]

I wrote the following simple expression to bring out some enum options for an enum column in the ValidIf text box.

IFS([Involved Bowel Segment]=“Transverse Colon”,{“Proximal”,“Mid”,“Distal”},[Involved Bowel Segment]=“Rectum”,{“Upper”,“Mid”,“Lower”})

But it receives the following error.
Expression ‘IFS([Involved Bowel Segment]=“Transverse Colon”,{“Proximal”,“Mid”,“Distal”},[Involved Bowel Segment]=“Rectum”,{“Upper”,“Mid”,“Lower”})’ could not be parsed due to exception: #VALUE!.

Can anyone tell me what’s wrong with it?
Thanks

[Suvrutt_Gurjar]

Hi @djmalaka,

I believe the reason for error is that the enum options you are using in your expression are also used as function names in AppSheet .These words are “Upper”, “Mid"and"Lower”. There are AppSheet functions exactly by these names. Such words are typically reserved words as the parser could interpret them as functions instead of enum text options. You could slightly alter these words , e.g say “1Upper” from “Upper” and “2Mid” etc.

I believe then your expression will parse.

[djmalaka]

Thank you very much.