Column selection for Sheet Summary formulas?


Hi Everyone,

I am trying to select a row for a sheet summary formula, but it keeps giving me an #UNPARSEABLE error. It is working fine for other columns - however I notice on the ones where it is working the column range is linked, but not for the one I am having an issue with.

Here is the one that is not working:

Here is the one that is working as expected:

For the formula where I am getting the error, I clicked a cell in the column, so I know the column spelling is correct, so why is it not picking up the column like it did for the Region column? Is there another way to select the entire column for a formula?

Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!