Sheet Summary

Razetto

Hi,

When copying a sheet summary to other sheets within the same workspace, it carries the field names but not always the information within the field. For example, after having copied the sheet Summary, the "Completion %" shows =[% Complete]30 + " %" or #UNPARSEABLE, instead of an actual number, ie. 50 %. There's no option to link the field to the actual information from another sheet, is it?

Thanks

Andrée Starå

Hi Mozetto,

The sheet you're copying the Sheet Summary to has to have the same column, column types, and names as the original for it to work.

Did both sheets have the same columns?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Razetto

Hi Andree,

Thank you for your explanation, it makes sense. In our case each sheet has different information on the same project.

Take care

Andrée Starå

Happy to help!

We could probably make it work with a couple of helper columns on the sheets where the columns don't match up.

Would that work?

Razetto

Hi Andree,

It is a good alternative. I was hoping to take advantage of the information gathered within the Sheet Summary fields instead of what's within the sheet itself.

I appreciate the feedback!

Andrée Starå

Can you explain in more detail how you would like to use it? There might be a solution/workaround.