SUM function not working on cells with formula


I faced an issue with the SUM function, since it seems to not work on a column in which the cells contain a formula to return a number.

The cells that i want to SUM contain (JOIN(COLLECT)) formulas that pull data from another sheet. When I insert =SUM([Total Price]1:[Total Price]70) the SUM just returns 0. Also if I highlight the column by clicking on the header the SUM is not showing up in lower right corner as it does otherwise. The type of the column is Text/Number.

What am I missing for the SUM to work properly?

Thank you for any advice in advance.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!