Contact Columns marked Multiple Don't Populate Legacy Reports

I have 140 or so projects I manage reporting on and was excited to see that we could now do multiple contacts in our Assigned To column. However, when adding new projects with this feature enabled I noticed that Reports count those columns as different than other Assigned To columns without this feature enabled even though they have the same names.

I really don't want to have to go through 140 existing sheets to click a check box on a single column to enable this feature for my PMs. Is there a way to get the multiple contact Assigned To columns to populate in the same space on a report as the Assigned To columns without that feature enabled?

Find more posts tagged with

Contacts

Reports

IT & Operations

Product Development

Project Management

Comments

Andrée Starå

Hi,

Unfortunately, at the moment it isn't possible. I know that the Smartsheet team is working on making changes/updating it.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Daniel Stein

Thanks for your question. Andree is correct that we are currently looking into automatically combining single- and multi-contact columns that have the same name in reports, in response to customer requests.

In the meantime, you are right that you would need to turn on the feature in all underlying sheets referenced by the report, then swap out the column in the report. Steps are here.

Best regards,

Daniel

Daniel Stein

Hi all,

We shipped an enhancement to reports so that they now automatically combine data from contact columns that have the same name, regardless of whether "Allow multiple contacts per cell" is turned on. So for all new reports and most existing reports, you'll no longer see 2 versions of the same column.

If you had already added both the single- and multi-contact version of the column to the report, you'll see that all the data is now combined under one column, and the other is blank. You can go ahead and remove the blank column from your report.

Best regards,

Daniel

Sign in to join the conversation!

Quick Links

Trending discussions

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…