-
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…
-
Method to show comments from a sheet on a dashboard
Hello, Is there a way to surface just the comments from a sheet into a dashboard? Right now I have a report where the comments are seen at the row level, which is a step in the right direction. The limitation is I can only see the comments in either the report or the sheet. The ultimate desire would be to display comments…
-
Metrics Sheet Pulling from Reports
Hello All, I'd love to know if its possible (or a workaround) for creating a metric sheet to use in a dashboard using data from reports. We have 90+ Sheets that we can easily pull data into a report but its hard to get that into a meaningful chart. One specific example is we have 90+ sheets with rows that contain a rating…