Sheet Summary Report - Multiple Instances of the Same Fields

Steven Kopischke

I have created a template for our PMO to use and a report based on the sheet summaries each sheet contains. Older projects have had the sheet summary fields added, rather than migrating existing projects to a new sheet based on the template.

Something odd is happening - some fields are appearing twice in the column selector in the report. A few examples in the below screenshot:

How do I get the summary report to recognize that all fields with the exact same name should be the same column?

Andrée Starå

Sheet Summary Report - Multiple Instances of the Same Fields

Steven Kopischke

Jun 12, 2024

I have created a template for our PMO to use and a report based on the sheet summaries each sheet contains. Older projects have had the sheet summary fields added, rather than migrating existing projects to a new sheet based on the template.

Something odd is happening - some fields are appearing twice in the column selector in the report. A few examples in the below screenshot:

https://us.v-cdn.net/6031209/uploads/89HEOFJNBOS3/image.png

How do I get the summary report to recognize that all fields with the exact same name should be the same column?

---

View Post

Hi,

I hope you're well and safe!

Please double-check that the names match precisely and are the same type.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Steven Kopischke

Thanks.

Now I have a new problem. A field only appears once in the field selection, but it's the wrong, and now-unused, version of the field. How do I reset the report to recognize the correct field?

Andrée Starå

Steven Kopischke

Jun 12, 2024

Thanks.

Now I have a new problem. A field only appears once in the field selection, but it's the wrong, and now-unused, version of the field. How do I reset the report to recognize the correct field?

If you scroll to the end of the column selection in the report, you can remove the ones that don't match.

Did that work/help?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Steven Kopischke

Thanks. That did help. I didn't expect to see the field listed out of alphabetical order.

Andrée Starå

Steven Kopischke

Jun 13, 2024

Thanks. That did help. I didn't expect to see the field listed out of alphabetical order.

Excellent!

Happy to help!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!