AnsweredAssumed Answered

If Calculation

Question asked by JodieWeston on Jun 8, 2018
Latest reply on Jun 11, 2018 by onefish

Help, please


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 ...