Why is SmartSheet sometime so dumb......?
Options
I'm trying to do something that should be so simple.....
I have a several values in a column "A" in a $ format. I want the last row in the column to calculate 5% of the total of above columns. Why does the formula =SUM([Column A]1:[Column A]10*(0.05)) not work...
I'm sure there is some SmartSheet logic, which I don't know that will make this work, but why does the above formula not work? Why would the developers stray so far from basic spreadsheet logic?
Comments

=SUM([Column A]1:[Column A]10) * .05
You are including your multiplication inside of the SUM function. That's probably why it isn't working for you. Your formula is basically saying to multiply the range by .05 then SUM.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!