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?