Control Center: Global Update Column with different Row Formulas

Marie Toft

I have created a Sheet that has different formulas by row and not one consistent Column Formula. I have saved this as part of the blueprint template. And now I want to add a few columns that show the % mix of different categories. (see image below)

To update already provisioned projects, is there a way to do this through a global update? When I tried to walk through the global update column, it appears that it may only allow you to apply a full column formula? Is there a way to apply the exact column that I created in thr blueprint with the particular formulas by row in tact? I tried and could not seem to get it to work.

If not, how best should I consider adding new columns to an existing template for already provisioned projects? Create a new Optional Template with these new columns and then add it to already provisioned projects? (deleting the old sheet that does not have this column)? Will the formulas work and link to that projects source data?)

Paul Newcome

You would need to figure out a way to combine each of the different formulas into a single larger formula with an identifier as to which one should run.

For example:

If you have one formula on child rows and another formula on parent rows, you would use an IF statement to output one or the other depending on the count of children.

=IF(COUNT(CHILDREN([Task Name]@row)) = 0, child_row_formula, parent_row_formula)

Marie Toft

You read my mind! I was thinking that creating a larger single formula was going to be the answer. The only problem is that I have different number of rows for each category....but maybe I can get a bit more familiar with Parent and Child formulas b/c I do think you are correct in that I can "tweak" this formula to work for different number of children (rows) per category.

I'll give it a try and let you know.

Thanks!

Paul Newcome

It looks like leveraging PARENT and CHILDREN functions will definitely help you with this.

Andrée Starå

Hi @Marie Toft

I hope you're well and safe!

To add to Paul's excellent advice/answer.

• You can also add specific formulas to rows/ranges.
• If the structure is identical, you can use the Row Numbers. What I sometimes do in my client solutions is add identifiers to make it simple to make updates.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!