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

edited 12/09/19 in Smartsheet Basics

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.




  • Andrée Starå
    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!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


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

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.