What is wrong with this formula?

acarra02
acarra02
edited 05/09/24 in Formulas and Functions

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

  • IEPE
    IEPE ✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!