How would I go about creating a dashboard for each employee so they can see all their open items. I cant do a report because that means every time we add a sheet we have to add it.


  • Samuel Mueller
    Samuel Mueller Overachievers

    could use a workspace and in the report select the workspace instead of the individual sheets. Have common naming for the sheets you want to include an in your report filter to SheetName contains the common naming.

    Like Tasks - Employee Name

    the sheet name contain criteria will be "Tasks - "

    new sheets would auto add to the report, then you can also use the current user filter.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!