I would like the calculation field to note "Imported" when any or all of the four fields ( Feedback supervisor status; Feedback Science status; Feedback ShowrunnerA status; and Feedback Feedback ShowrunnerB status) contain "YES". I created the calculation below. However, whenever I try to save it, I receive an error message (see below):
If ( Feedback supervisor status = "YES" ; "Imported" ; If ( ClientFeedback Science = "YES" ; "Imported" ; If ( Feedback ShowrunnerA status = "YES" ; "Imported" ; If ( Feedback ShowrunnerB status = "YES" ))))
I can't figure out what I'm doing wrong ...