-
Help with COUNT forumula for column with duplicate names.
Afternoon, I am creating a reporting dashboard to report employee stats. Each of the metrics on my dashboard is fed from a dashboard calculation sheet. Each of the sections in my dashboard calculation sheet references another sheet based on different criteria. In each of these sheets, i have a column with employee names…
-
Filter report to only items where comments mention specific text
I'm looking to create a report that will show me only the records where I am mentioned/tagged in the comments. This is not a comments column, we are using the standard 'comments' functionality. Would even be sufficient to just filter on any rows where the comments are like '%SomeText%'. Seems fairly similar to this post…
-
Trying to set up Corrective Action system using smartsheets
My company has been using smartsheets for order tracking and data reporting, but I'd like to try to use it for our corrective action system (we are AS9100). Currently we just use a controlled document to gather all of the data and put it in a folder that's manually created on sharepoint. I want to create a sheet to track…
-
Sheet Name Hyperlink Navigation problem/proposal
I have a dashboard with a summary report that shows all my records within my Smartsheet, within the report i have the sheet name column which acts as a hyperlink and takes the user to the associated sheet where the record is located. The problem is the link takes the user to the page but leave the user having to go and…
-
Filter Capability and Control for Published Smartsheet Reports
I have a really great report I created from a Smartsheet that would be almost perfect if the published report could be filtered, specifically only with the filters that I allow people to use. Why? Because currently I have to give each individual who requests it, access to my report, which is tedious …but they need to have…
-
Merged: Create report from within a sheet
This discussion has been merged.
-
Can't share info on mobile device via Dynamic View OR Workapps?? what is the solution then?!
SO we can't share via reports unless we add all users to the sheet. SO we buy dynamic view and enterprise licensing and add our dynamic views to a dashboard and share the published dashboard. SWEET, wrong. Now we can't use dynamic view when viewing the data by mobile devices (and that is our whole point- easier access/view…
-
Reports: sharing requirements to @mention in comments
I often run reports to gather specific teams' data across multiple schedules into one easy-to-access place. I realized recently that report users cannot @mention people in comments, even if those people are shared to the base sheet being pulled into the report. Instead, the @mention must also be shared to the report. I…
-
Creating A Report of Missing Submissions
Hi Community! I have a form deployed to community partners. These partners need to submit a report 1x per month. Of course, some do not submit the monthly report. Is there a way for me to create a report of missing submissions? I have a reference of all partners who should be submitting a report and the sheet from the form…
-
Enviar un informe solo si contiene datos
Quiero configurar el envío automático por correo de un informe. De manera que se envíe todos los días que contenga datos, pero NO cuando esté en blanco. ¿Es posible? No encuentro la opción ya que configurando el envío desde el informe no me deja agregar condiciones. Y tratando de hacerlo desde una hoja, sí puedo agregar…