Smartsheet not generating SUM for Text/Number column.


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.
    Genevieve P. Employee Admin

    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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!