Setting Formula to Dynamically Total Columns Available

[knobsdog]

I have a workflow that has changing columns.  Sometimes there might be 5 columns, sometimes 3, etc depending on volume of certain items.  I need to manually calculate the total of those 5 columns regardless of what's there but not other possible items.  There's like 15 possible columns but we only use 5.  Is there a way to dynamically total what ever of the 5 columns shows up?

[fmvizcaino]

Hi @knobsdog ,

You can use a transpose tool to guarantee a dynamic calculation of all the columns by transforming them all to rows.

Best,

Fernando Vizcaino

[knobsdog]

I've tried that but I can't seem to get the data back into the previous layout.

[fmvizcaino · Accepted solution]

Hi @knobsdog ,

Sorry, I've sent you the wrong file.

Check if this works for you.

Best,

Fernando Vizcaino