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'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?
