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å

https://community.smartsheet.com/discussion/123241/sheet-summary-report-multiple-instances-of-the-same-fields

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å

https://community.smartsheet.com/discussion/comment/440526#Comment_440526

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å

https://community.smartsheet.com/discussion/comment/440647#Comment_440647

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!