Sum of values across Arrays/Lists

edited 12/09/19 in Formulas and Functions

Hi there,

I have a column that shows a set of values like this:

             COLUMN A

Row 1   20:40:0:0:20:0

Row 2   2:4:0:0:0:4

Row 3 .  0:0:0:0:0:0


Each row represents a project task.

The value represents the number of employees needed for the task across 6 different employee types/categories (categories separated by ":").

I need a formula the generates a SUM of the respective categories across all rows.

In this example the result would be:

Result   22:44:0:0:20:4

Any advice is greatly appreciated



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!