simple total column

I have set up 2 sheets similar to the inspection submissions and metrics template i found in the solutions center. I use it to collect postage cost per month. I have the submissions feeding into the metrics page with a SUMIFS formula. All of that is working fine. However when I want to total the row for a monthly total with a basic =SUM formula, it is not returning the correct value. What am I missing?

ss (2).png

Find more posts tagged with

Finance

Formulas

Services

Project Management

Comments

Mike Wilday

Have you tried =A5+B5+C5 without the sum formula? What does that produce for you?

CarriG

Thanks for the reply.... it just populated by itself with the correct values. Must have been on a delay, who knows? Kind of strange but its working now.

Mike Wilday

Great. That is a really strange error. But then again, Smartsheet tends to have those more often than I'd like.

Sign in to join the conversation!

Quick Links

Trending discussions

seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…