Index collect formula


Can anyone help me with a formula? I am trying to sum a column from another sheet based on what is selected in a multi select dropdown. I worked with the Pro Desk at Smartsheet and they provided me with this formula, however its not working . Perhaps I have parenthesis or comma off someplace??

=IFERROR(SUM(INDEX({Team Revenue PY and YTD 2023 -2023 YTD}, COLLECT(HAS(@cell, [Producer/Team Name(s)]@row, {Team Revenue PY and YTD 2023 Prod/Team Name}), 0))), "")


Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!