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([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!
Best Answer
-
=IF(OR([Training1-Attended]@row = "Yes", [Training2-Attended]@row = "Yes", [Training3-Attended]@row = "Yes", [Training4-Attended]@row = "Yes"), "Yes", "No")
Answers
-
=IF(OR([Training1-Attended]@row = "Yes", [Training2-Attended]@row = "Yes", [Training3-Attended]@row = "Yes", [Training4-Attended]@row = "Yes"), "Yes", "No")
-
Thank you - that worked! I appreciate your help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!