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

 

Thanks,

Jodie

Outcomes