=IF(OR, how many (OR's?
I currently have an =IF(OR formula that works well. Now I need to expand the entries it looks for in the given cell to include two more criteria. As it works:
=IF(OR($[Employee/Contractor]@row = "John Doe", $[Employee/Contractor]@row = "Jane Doe"), $[Time - Rounded]@row, $[Time Worked = Bill Rate]@row)
How I now need to expand it:
=IF(OR($[Employee/Contractor]@row = "John Doe", $[Employee/Contractor]@row = "Jane Doe", $[Employee/Contractor]@row = "Piglet", $[Employee/Contractor@row = "Pooh"), $[Time - Rounded]@row, $[Time Worked = Bill Rate]@row)
Should it now begin and end: =IF(OR(OR(OR($[Employee/Contractor]@row = blah, blah, blah $[Time Worked = Bill Rate]@row)))
Or is adding more (OR statement not possible? I keep getting UNPARSEABLE and INCORRECT ARGUMENT SET errors
Thank you. Jerry
Answers
-
Hi @jb@59069
You're correct, there don't need to be any additional OR functions added. I'm glad you got it working!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!