Smartsheet not generating SUM for Text/Number column.

Andrew Thomas

Hello.

Smartsheet allows me the add the "Total Amount of Cash" text/number column and generate the contents of each cell (bottom snap). When I try to create a summary for that column (like the "Total Amount of Credits..." column to the right) the search box does not recognize the column (top snap).

I created a companion "Test" column ("= value in column to left"), converted to column formula, in the source sheet and Smartsheet did create a summary for that. What am I doing wrong/how do I fix?

Thanks for your help.

Genevieve P.

Hi @Andrew Thomas

How are the values being entered into your "Total Amount of Cash Approved (in millions)" column being populated? If they're recognized when using the VALUE function, then this seems that the current column is seeing these values as text, not numerical.

If you're using a formula, can you paste the formula here?