Two Columns Named 'Assigned To'

Hello.

I have a report that pulls milestones from multiple project plans. I created this report from a template within Smartsheet.

There are two columns named 'Assigned To'

Can you provide any answers as to why they seem to be duplicated and pulling information differently?

Note that I have multiple shared project plans as well as a non-shared project plan that I'm pulling data from. I'm not sure if that's the cause of the duplicate column names.

Thanks for any help!

Troy

Smartsheet Snapshot.JPG

Find more posts tagged with

Reports

Project Management

Comments

TKeller

Hi Troy,

I just had this happen also. Check to see if some of your projects have "Allow Multiple Contacts Per Cell" checked - Go to the project, Task Assigned To tab, edit Column Properties, and see if this is checked. If some do, some don't, it will display that column twice.

Daniel Stein

Thanks Troy for your question.

Reports currently treat contact columns that do vs. don't have "Allow multiple contacts per cell" checked as different column types, meaning their data will show up in different columns in the report. To combine the data, you can turn on "Allow multiple contacts per cell" on all of your underlying sheets. Details are in this support article.

In response to customer feedback, we are currently working on enabling reports to automatically combine data from contact columns that share the same name, regardless of this setting.

Best regards,

Daniel

Troy Filson

Thank you so much! That seems to be the issue.

Have a great week ahead.

Troy Filson

Thank you, Daniel. I'm pleased to hear that you're busy working on the issue based on customer feedback. That sort of customer response will set you apart from your competitors. Well done.

Appreciate the workaround suggestion and your quick reply.

Kind regards,

Troy

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…