Adding various formula cells in a row

Gavin Seaton

Hi Everyone, sorry if this is a bit basic but I'm new to Smartsheet and can't work out how to add several cells in a row that are in formula columns.

I thought using the SUM formula shown below would suffice but it keeps returning a 0 rather than 200.

Any help on this would be appreciated.

Genevieve P.

Hi @Gavin Seaton

What are the formulas in your Column Formula columns? It looks like the values are being returned as text string instead of numerical (see the question "Why are my numeric values not calculating correctly?" at the bottom of the Frequently Asked Questions About Using Formulas article).

We can either adjust your Column Formulas to output numerical values, or you can use the VALUE() function wrapped around each referenced cell in your SUM Formula:

=SUM(VALUE([Cell 1]@row), VALUE([Cell 2]@row))

Let me know if this works for you!

Cheers,

Genevieve

Andrée Starå

Hi @Gavin Seaton

I hope you're well and safe!

Strange!

It should work.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @Gavin Seaton

What are the formulas in your Column Formula columns? It looks like the values are being returned as text string instead of numerical (see the question "Why are my numeric values not calculating correctly?" at the bottom of the Frequently Asked Questions About Using Formulas article).

We can either adjust your Column Formulas to output numerical values, or you can use the VALUE() function wrapped around each referenced cell in your SUM Formula:

=SUM(VALUE([Cell 1]@row), VALUE([Cell 2]@row))

Let me know if this works for you!

Cheers,

Genevieve

Andrée Starå

@Genevieve P

Good catch! I always miss that.

Genevieve P.

Haha, no problem! It's such a small thing to miss. I've learned to quickly look to see if the numbers are on the left or the right of the cell before troubleshooting anything else. 🙂

Gavin Seaton

Thanks for your offer of help @Andrée Starå

@Genevieve P That was exactly the issue and adding VALUE to the calculation sorted it.

Thank you.

Gavin

Genevieve P.

Glad you were able to figure it out! Let us know if you have any other questions - @Andrée Starå is a Smartsheet wizard.

Andrée Starå

@Gavin Seaton

You're more than welcome!

I'm always happy to help!

Have a fantastic weekend!

Andrée Starå

@Genevieve P

Thanks! 🧙‍♂️