Limited Columns displaying from linked sheet in a Report

LaShawnda_K.

I'm trying to create a report that can tell me which resources are working on active tasks in my Request Tracker. Some of the tasks are inactive tasks while others are actively being worked by resources.

When I create a form to pull this information and link to the Request Tracker sheet, I only see about 6 of my fields as options of columns to display.

Is it possible I have too many fields in my request tracker and Smartsheet can allow me more than the 6 options?

If it helps, I have about 20 fields in my tracker.

Paul Newcome

Are we talking about a form or a report? Are you able to provide some screenshots for reference?

LaShawnda_K.

I'm trying to create a report.

When I add a sheet to the report to pull info from. I don't see all of the fields in the sheet as options. The sheet that I'm using in the form has 20 fields but only 6 fields are listed as options.

Andrée Starå

Hi @LaShawnda_K.

I hope you're well and safe!

Ensure that it's the correct report type (Row, Sheet Summary).

Did that work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Are you able to provide some screenshots for reference?