Report not reading contact list field from source sheet

Kendra Michaels, CAPM

Greetings Smartsheet Community! I'm having an issue building some reports.

In my source sheet, "Art Requests", I have a contact list column called "Designer". This is where the project request (submitted via Form) will be assigned. I have defined the options in the dropdown.

When I go to build a report to make one of the Designer's Action Item list for the team dashboard, no contacts show up in the Report Builder. I've tried other contact columns (Submitter, Sales Owner) and the contact options in those fields pull through with no issue.

I have no clue what is broken or not working. Help me!

PS: The only difference formatting-wise in the source sheet between "Designer" and the other contact list columns is I have a cross sheet formula reading the "Designer" column for some charts.

PPS: I have successfully done this exact thing using a different sheet to achieve the same goal. So I'm EXTRA confused at what isn't working.

Paul Newcome

When building a report, it won't let you specify data that does not exist on the source sheet. You will need to create some filler rows (which can later be deleted) with each data point in them, then build your report.