Smartsheet not generating SUM for Text/Number column.
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.
Answers

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
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!