Multiple IF statements formula help

Allison Guerin

I am tracking completion of trainings by participants in our organizations using the Symbols fields and I would like to have one column that tells me if each participant has completed at least 1 training. I am trying to do this by using a formula with multiple IF statements but I keep getting an Incorrect Argument Set error.

Each column is formatted as a symbol with attending the training coded as "Yes". Here is the formula I am currently using:

=IF(OR([Training1-Attended]@row = "Yes", [Training2-Attended]@row = "Yes", [Training3-Attended]@row = "Yes", [Training4-Attended]@row = "Yes", "Yes", "No"))

What am I doing wrong? Any help would be much appreciated!

BullandKhmer

=IF(OR([Training1-Attended]@row = "Yes", [Training2-Attended]@row = "Yes", [Training3-Attended]@row = "Yes", [Training4-Attended]@row = "Yes"), "Yes", "No")

BullandKhmer

=IF(OR([Training1-Attended]@row = "Yes", [Training2-Attended]@row = "Yes", [Training3-Attended]@row = "Yes", [Training4-Attended]@row = "Yes"), "Yes", "No")

Allison Guerin

Thank you - that worked! I appreciate your help!