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:
Id like to summarize status for a list of users involved on multiple project checklist. The dashboard function tells me I can only use numerical data in reports/widgets. Is there something I am missing? I want to provide a quick glance at overall status of multiple checklists.
Hello,
Your data needs to be aggregated and calculated in a sheet first.
You'll want to create a function that counts these values, such as COUNTIF or COUNTIFS.
Then, you can use a metric widget to bring in the counted values.
More information on these functions is available on our functions page: https://help.smartsheet.com/functions
Hi, I am wondering if there is a solution for this scenario: I have a Data Shuttle data upload workflow to a Target Sheet that is updated when a new attachment is added. Question: is there a function/features/workaround like Data Shuttle, Bridge, or a combination of features so that if a new column is added to the Excel…
I have downgraded to business but no longer have access to my sheet,i get an error 48,get licensing? How do I fix this? This is a customer contact form so i cant recreate it as the email has been sent?
I have been given access as an Admin to edit an existing sheet but cannot edit columns. I am a System Admin. I am a paid Member. I am able to edit information in the sheet but cannot add a column.
