Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Is there any way to set the status for a sheet so that it displays as a custom column in a folder? For instance, a status of "closed" so the admin knows the sheet can be exported and deleted?
Hi David,
There currently isn't a way to display the status of an entire sheet on the Home tab (where you see all of your folders and items).
You might consider including a row in all of your sheets that holds a sheet status. You can set that row's status to "closed" and then run a report to look for all "closed" rows. As long as your report includes the Sheet Name column, you'll be able to quickly find what sheets you'll need to export and delete.
More on reports in the help center: https://help.smartsheet.com/articles/522214-creating-reports
We created "Closed Projects" folders in different workspaces. When a project is completed we add "CLOSED" to the end of the sheet name and move the sheet into that folder. When we run our report builder we exclude any sheet that has "CLOSED" in the title. Hope that idea helps.
Best,
Archie
I have a very simple use case: a sheet contains a Status column with values such as Completed, On Hold, and In Progress. I would like to create a dashboard chart showing the count of items per status. This feels like a basic capability that tools like Excel handle automatically by aggregating categorical values. Why does…
I am building a dashboard showing data entered into 1 overall workbook. Teams have been given a target amount to hit, so I have also created a second sheet showing a chart/grid that rolls up all the information and compares against targets using formulas calling back to the initial input sheet. If I publish this roll-up…
Hi Smartsheet Support Team, We are currently experiencing a critical issue with our Smartsheet application that is impacting multiple users in our organization. Symptoms: When trying to open Smartsheet, the app gets stuck in a continuous reload/refresh loop and fails to load the workspace or sheets properly. Additionally,…
