Multiple IF statements formula help
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([Training1Attended]@row = "Yes", [Training2Attended]@row = "Yes", [Training3Attended]@row = "Yes", [Training4Attended]@row = "Yes", "Yes", "No"))
What am I doing wrong? Any help would be much appreciated!
Best Answer

=IF(OR([Training1Attended]@row = "Yes", [Training2Attended]@row = "Yes", [Training3Attended]@row = "Yes", [Training4Attended]@row = "Yes"), "Yes", "No")
Answers

=IF(OR([Training1Attended]@row = "Yes", [Training2Attended]@row = "Yes", [Training3Attended]@row = "Yes", [Training4Attended]@row = "Yes"), "Yes", "No")

Thank you  that worked! I appreciate your help!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 405 Global Discussions
 216 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!