I get an #INVALID OPERATION using SUMIFS with multiple criteria referencing a separate sheet.
I am having trouble getting this formula right.
I want to pull the qty of flooring scheduled to run in a given week (1-52) provided it requires one of 2 types of veneer. (Acacia 1220x077x1.5 or Acacia 1220x185x1.5)
=SUMIFS({Schedule File - 052820 Flooring}, {Schedule File - 052820 Week}, Week@row, {Schedule File - 052820 Veneer}, @cell = "Acacia 1220x077x1.5", OR(@cell = "Acacia 1220x185x1.5"))
Any help is appreciated,
Devin
Best Answer
-
Hi Devin,
You were very close! Try having the OR around the two options though, so it knows what the OR is between:
=SUMIFS({Schedule File - 052820 Flooring}, {Schedule File - 052820 Week}, Week@row, {Schedule File - 052820 Veneer}, OR(@cell = "Acacia 1220x077x1.5", @cell = "Acacia 1220x185x1.5"))
Here's more information on the OR Function: https://help.smartsheet.com/function/or
Let me know if this works for you or not.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi Devin,
You were very close! Try having the OR around the two options though, so it knows what the OR is between:
=SUMIFS({Schedule File - 052820 Flooring}, {Schedule File - 052820 Week}, Week@row, {Schedule File - 052820 Veneer}, OR(@cell = "Acacia 1220x077x1.5", @cell = "Acacia 1220x185x1.5"))
Here's more information on the OR Function: https://help.smartsheet.com/function/or
Let me know if this works for you or not.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you very much! This is awesome. I'm still learning the @cell syntax.
-
No worries at all! Glad this worked for you 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 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!