SUM of Values separated by a comma in the same sheet


#1

Hi,

I have a Zap importing values separated by a comma - I cannot change this. So my field looks something like this: 55.00,55.00

I am attempting to create a sum from these values, but the ending value is 0.00

I do not want to create a rollup field on another sheet only to import the values back into the original sheet - that’s double redundant and another thing to keep track of.

Is there a formula that can combine those comma-separated values into a sum?

Thank you


#2

I think you can use FIND() and INT() to extract the numbers and them sum them: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference#text


#3

Thanks - Would you have a formula handy?


#4

Try

IF(
    {Your Variable},
    VALUE(
        LEFT(
            {Your Variable},
            FIND(',',{Your Variable})-1
            )
        )+
    VALUE(
        RIGHT(
            {Your Variable},
            LEN({Your Variable})-FIND(',',{Your Variable})
            )
        )
    )