Formula not working with single select field

1167 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have struggled and failed to get a simple formula work, so I did some testing and seem to have identified a condition in which Formula does not work.

It is a simple IF statement.

IF({Student Status}=“Active”,{Sponsor Last Name}.

If the Student Status field is a single line text, it works. If the Student Status field is a single selection field, it does not.

Any suggestions?

2 Replies 2

It should work with {Student Status} as a Single Select field. I’ve done that plenty of times myself.

My suggestion is to check for typos. The text you are matching against in your formula has to be exactly the text of the Single Select option, including white-space and capitalization.

Otherwise, I see no reason why it shouldn’t work with a Single Select field.

11 - Venus
11 - Venus

Hi @Gary_Nelson

Also, check to make sure you are using straight quotes.

Mary K