...more specifically, if a field using a lookup rule is E, I need EXEMPT, and if the lookup rule returns N, I need NON EXEMPT, etc. I've tried two separate fields with IF and SUBSTITUTE calculations, but just haven't gotten it to work. Is the only way to do this by writing in JS/jQuery? If not, what might be easier? Any help or guidance would be greatly appreciated.
Thanks