What is wrong with this formula?
I am trying to summarize the quantities of each different sized container that is also checked as being shipped off-site to use in a dashboard pie chart. I tried the following formula, but I get '#unparseable'. What do I need to fix? Or coincidentally is there a better way, using reports, dashboards, however, to visualize all the items checked off to be shipped by quantities of the varying container sizes?
=SUMIFS([# of Containers]:[# of Containers], [Ship Off-Site]:[Ship Off-Site], 1, [Container Size mL:Container Size mL], 2000)
Best Answer
-
Hola, creo que solo falta poner correctamente los simbolos de columna ] [ :
=SUMIFS([# of Containers]:[# of Containers], [Ship Off-Site]:[Ship Off-Site], 1, [Container Size mL]:[Container Size mL], 2000)
espero te ayude. saludos
Answers
-
Hola, creo que solo falta poner correctamente los simbolos de columna ] [ :
=SUMIFS([# of Containers]:[# of Containers], [Ship Off-Site]:[Ship Off-Site], 1, [Container Size mL]:[Container Size mL], 2000)
espero te ayude. saludos
-
Muchas gracias! A pensar que la solucion era tan simple y no lo veia.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!