Creating a running total column in my structure

[Alex Molotski]

Hi,

I'm trying to create a column with a running total in my structure.

The purpose of this column is to sum up all the efforts of a certain team, the efforts are hosted in a different column.

My structure is ordered by SW Rank, and I want to be able to see at which epic the efforts of a certain team is larger than the head count I have (we call it a red-line).

As you see in the below example screenshot, I have at team called MCS FW and the column contains the effort of this team per epic, and I would like to have a column next to with a running total so I can see when my capacity is over.

Thanks for you help!

[Stepan Kholodov _Tempo_]

Hello @Alex Molotski 

You can certainly compare each Epic's Effort value with something else using the Formula column. You just need to define the compared with value. For example, if the headcount is present as a custom field value in each Epic, then you can use a formula like this:

if mcwfweffort > head_count_field_name: "too much effort"

or if the head count is a free number, you can manually define it in the formula like this:

if mcwfweffort > "10" : "too much effort"

I hope this helps. If you need further assistance with the formula, or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)