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
We are UK based and use the Day/Month Date Format (i.e 09/02/2026 - 9th of Feb 2026) In some, but not all, of the "Send.." rows email, the date format changes to the American version (02/09/2026). Is there any way to stop this happening?
Hello, I have an approval path for update requests. It starts with a form, and it currently isn't being received after being handed off by the PCM. So, starting on page 3, the Area Director isn't receiving the update request. I have myself filled in for most of the steps which will be changed once I get this sorted, but…
Earlier today it looks like several columns of data had the "clear contents" action taken in error. Is there a way to get that back other than using the snapshot feature and manually adding it back to a sheet with conditional formatting etc.? thanks in advance for taking a look1
