Hi and thanks for reading
I have a document to track where we pitch projects to two different entities. I have a field called PitchStatus that I’d like to update based on whether or not a value has been entered in one or two fields.
What I’m going for in playing English is:
If Pitch_ID is blank and Pitch_Oxy is blank, PitchStatus = “Pitch to Both”
If Pitch_ID is blank and Pitch_Oxy is not blank, PitchStatus=“Pitch to ID”
If Pitch_ID is not blank and Pitch_Oxy is blank, PitchStatus=“Pitch to Oxygen”
else PitchStatus = “Pitched”
I’ve been following along with the premium control flow course, and came up with this, but I’ve definitely messed something up:
if ID_Pitch = “”
TestPitchStatus = “Pitch to both”
elseif ID_Pitch = “” and Oxy_Pitch <> “”
TestPitchStatus = “Pitch to ID”
elseif ID_Pitch <> “” and Oxy_Pitch = “”
TestPitchStatus = “Pitch to Oxygen”
TestPitchStatus = “Pitched”
Thank you for having a look, and have a great weekend!