How do I sum deliminated values?

Binika Chunara

Steven Stikons

Hi Binika,

There really is no easy way to do this in Smartsheet. The only way I could come up with was to use two helper columns and another cell to sum the results in the second helper column to get the answer.

Here is a link to the sheet where you can view the columns and formulas: https://app.smartsheet.com/b/publish?EQBCT=015002edbb1645efad4876266aee6029

Steven Stikons

Hi Binika,

There really is no easy way to do this in Smartsheet. The only way I could come up with was to use two helper columns and another cell to sum the results in the second helper column to get the answer.

Here is a link to the sheet where you can view the columns and formulas: https://app.smartsheet.com/b/publish?EQBCT=015002edbb1645efad4876266aee6029

Binika Chunara

Thanks for your help Steven :)