Simple Addition
Hi everyone, I'm struggling to add in sequence. In the pic below i added (=89+100) = 89100 instead of 189. There is text in the indented groups. I also want the totals to move up and down when changes occur within the data, please guide me.
Answers
-
I would recommend using the SUM() formula... SUM(89,100)... instead of the + symbol. That being said, those values are either formatted to the left hand side, or being stored as text. If they are being stored as text you can convert with the VALUE() formula so they can be used as numbers.
Best,
Zach Hall
Training Delivery Manager / Charter Communications
-
Hi,
Try using =SUM and the rows.
Also you might want to download the formula handbook it is a huge help. You can find examples of using SUM and the link to the handbook in this article : https://help.smartsheet.com/function/sum
Marlana
MARLANA KALINOWSKI
Sr. Business Analysts / Smartsheet Solutions
National Pharmacy Services | Genoa Healthcare
-
Thanks for the help, I'm getting #UNPARSEABLE errors. I've scheduled a session with the consultants.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives