-
Need help with creating report(s) with data from a Survey
Hello, I am still fairly new to Smartsheet and need some help turning around data from a survey I sent out. I have 600+ responses that I used the Request an Update function in Smartsheet to obtain, that I now need to summarize and I have no idea how to start the summary process. The survey is regarding Security Services at…
-
Reports & Proofing to Person outside Organisation
Hello, we are outsourcing some drawing to a freelance CAD Technician outside our organisation. I have setup a Report that has a number of source sheets and have added a checkbox column in the source sheets if the drawing is to be outsourced. When checked that item shows up in the Report (for all internal organisation…
-
Using "Current User" functionality
Hi Smartsheet Community! I have trouble utilizing "Current User" in report. This is my Grid. "Assigned To" field is mapped to user names, using "Contact List" as column Type Yet when create a report with this column, filter would not show "One of" as filtering option. Hence I won't be able to select "Current User"…
-
Current User Views on Reports/Dashboards
Hello! I am trying to create a dashboard for internal, unlicensed users to see tasks assigned to them, and I seem to be missing something because I can't get it to work. I have a report filtered to current user: I have the report on the dashboard set up to show the viewer's data: I have the user shared as admin to the…
-
Dashboard/Report link issue
Hi everyone, A person on my team has created a dashboard with a report widget that has a link at the bottom on it. The report itself has over 700 line items, which is over the 150 max per this article: https://help.smartsheet.com/articles/2482269-using-report-widgets We would like to remove the link. Alternatively, how do…
-
Can I setup conditional formatting based on a time function?
Hello! Is it possible to setup conditional formatting based on a time function? For example, I want a cell to turn red if it hasn't been updated by 12noon. Or, I want a cell to turn red if the current time is after 2pm.
-
Sharing a Report
Hello, I have created a report from master employee data. I want to share the report to another department that doesn't have access to the master data (for confidentiality reasons). How do I do this? Thanks, Hannah
-
Update on: Edit a reports without access to the underlying Smartsheet.
Is there any update on this function or a new workaround? Please see here: https://community.smartsheet.com/discussion/5916/editing-reports-without-having-access-to-the-underlying-sheet or https://community.smartsheet.com/discussion/17606/allowing-people-to-access-reports-without-having-access-to-the-main-sheet This…
-
Report formatting on dashboards
Hi there, Is there a way to format reports on a dashboard so that when displaying in gantt view the columns to the left with the data remain static and the gantt chart is extended? When I display gantt reports on a dashboard the last column with the data tends to extend and then I have to drag the columns and resize each…
-
Summarizing items by country
Hi there - I am working on a dashboard and would like to summarize content created in a region and then by country. Right now I have this set up manually with a formula based a static list of countries, but I am hoping there is something I could do that would pull the country list automatically from the column, as new…
