Report Builder: Adding Column in report that does not exist across multiple workspaces

bcarlson

We make use of multiple shared workspaces and users then create a report that shows them all line items that they have been "Assigned To".  A user would like to be able then have a column available to her to enter her prioritization to work on the items.

For example, she may want to use a number system 1A, 1B, 2A, etc. or she may decide to use days of the week to label which day she will work on which items.

The only solution we have come up with is to create a unique column in each sheet in workspaces but we know that may fail over time as different users create different sheets. 

Thus the question, is it possible to add a column to a report for this user to use.

Beth

Andrée Starå

Hi Beth,

The only way is to add that column to the sheets she wants to set priorities for. I would recommend adding those columns to a template (either template type in Smartsheet or a regular sheet that's used as a template), and then you could hide them, so they are protected and not taking up space for others.

Would that work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting