Report Builder - Row Report - Who? not showing columns

jb@59069
jb@59069 ✭✭✭✭✭✭

I have tried this multiple times this morning but nothing is working. I began the way I normally do:

  1. Open an existing row report that I use as a base template, referencing a sheet in use;
  2. File, Save as new, give report a new name and save to a new Workspace;
  3. Open Report Builder, deselect the Where? item(s) for the old reference sheet(s), select new reference sheet(s)
  4. Select Who? and change the Employee/Contractor value(s) to display the new Employee/Contractor column value(s)

Here's where today's problems began. When attempting #4 above, the ONLY columns that appear under the Who?, are Created By and Modified By system columns. As you can see from the background of the image below, there are multiple columns in the selected sheet that is referenced in this report that I simply want to edit, yet none show up in the Who? selection.

I have also tried creating a Row Report from scratch and run into the same problem.

Answers to questions I'm sure will be asked:

I am the Owner of all things Smartsheet in our organization. I own the sheet(s) and report(s) I am editing and creating.

Yes, I am double, triple, quadruple sure I am using a row report.

Yes, this is a process I use almost daily so it is routine.

Yes, I have restarted my PC.


Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @jb@59069

    Since this is happening when you create a duplicate of a Report as well as creating a new Report from scratch, it actually sounds like there may be an issue with the underlying columns in the sheet.

    Can you double check that the Employee/Contractor column is set up as a Contact List type of column? You may also want to check the Report and see if this column is showing up under the What section instead... if so, it may be that the column is being recognized as a Text/Number column or a drop-down list instead of a Contact list.

    It would be helpful to see a screen capture of the source sheet and the Employee column if possible, but please block out any sensitive data!

    Cheers,

    Genevieve