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?