Counting values

ScottPinson_AlliedSolutions

I have over 30 sheets which I store the portfolio the belong to in a sheet summary field (a drop down). I am needing a way to count these values. I am wanting to count how many schedules have the value "ETG Project Portfolio 2020" in the Portfolio summary field.

thanks in advance for the help.

Andrée Starå

Hi @ScottPinson_AlliedSolutions

Depending on if the new report update that is coming soon will have grouping features for the Sheet Summary Reports. (I think it will work) You could use that.

Otherwise, the best option would be to link the Sheet Summary values to a row in each sheet and then link it to a so-called Master Metric Sheet.

Make sense?

Would that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @ScottPinson_AlliedSolutions

Depending on if the new report update that is coming soon will have grouping features for the Sheet Summary Reports. (I think it will work) You could use that.

Otherwise, the best option would be to link the Sheet Summary values to a row in each sheet and then link it to a so-called Master Metric Sheet.

Make sense?

Would that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

ScottPinson_AlliedSolutions

Thanks for the reply. that is what I has thought but thought someone might have an idea that I couldn't think of.

Thanks,

Scott

Andrée Starå

@ScottPinson_AlliedSolutions

I'm always happy to help!

Hopefully, the new report features will make this simpler. Soon we'll now!