IF statement inside a COLLECT

Options

Why do all of these formulas work:

SUM(COLLECT({Value}, {Location}, Location@row))

SUM(COLLECT({Value}, {Location}, <>""))

SUM(COLLECT({Value}, {Location}, IF(index@row=1, "Boston", Location@row)))

But this does not:

SUM(COLLECT({Value}, {Location}, IF(index@row=1, <>"", Location@row)))


I'm trying to understand this behavior - I have a hairy problem to solve which would be solved more easily with the bolded approach.

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!