Adding various formula cells in a row


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.

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    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!



    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!