Index collect formula

Options

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))), "")

Tags:

Best Answer

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!