Calculated Column based on answer from another field
Hello,
I am trying to create a enable/disable user account list/workflow. This list is tied to a workflow that sends an email out and that email is read by our TrackIT system and then put into a specific queue based on the title. So the title needs to be a specific thing. I’m trying to create a calculated column that equals a specific text, based on the response to another field. Basically, if the user selects “Create New Account” or “Disable New Account” I want the Calculated field text to be either A or B (just for this example).
Does anyone know how I could formulate this? I’ve been trying to do it on my own, but its quite difficult. I’m not sure where I’m going wrong.
Thanks,
Zayne
Hello, I am trying to create a enable/disable user account list/workflow. This list is tied to a workflow that sends an email out and that email is read by our TrackIT system and then put into a specific queue based on the title. So the title needs to be a specific thing. I’m trying to create a calculated column that equals a specific text, based on the response to another field. Basically, if the user selects “Create New Account” or “Disable New Account” I want the Calculated field text to be either A or B (just for this example). Does anyone know how I could formulate this? I’ve been trying to do it on my own, but its quite difficult. I’m not sure where I’m going wrong. Thanks, Zayne Read More