How to =SUM a column with GB and TB size values?

I am looking to get a total for a column that is using GB and TB data sizes. Is there a way to use the =SUM formula to find the total?

Ex:

3.91TB

3.21TB

5.8GB

7.3GB

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You will need a helper column that converts them into numbers. As it is, it is being stored as text strings which cannot be used in numeric calculations.


    =VALUE(SUBSTITUTE(SUBSTITUTE([Size Column]@row, "TB", ""), "GB", "")) * IF(FIND("G", [Size Column]@row)> 0, .001, 1)


    The above should convert everything into TB.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!