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 a way to automatically exclude sheets from reports if the sheet name contains a certain string?
Not directly. You could use a hidden column (we can call it [Sheet] for this example). You would then enter your sheet name in this column for all rows. Do this on all sheets.
Then in your report builder, you would include this new column in your What? criteria and say to exclude rows that contain "whatever string you want to exclude".
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,…
