-
Reporting on columns
Hi, i am trying to create a report based on user from multiple sheets. The report was working just fine about a month ago and now its not picking information correctly. I named the 2 columns in my sheets the Asset Type and I need the report to grab information based on user name so it becomes one column and my hardware and…
-
I need to SUM points based on user and then sort by aggregated points
I have a sheet similar to the one below: I need a way to display my results like this: I can create a report but it won't sort it based on the aggregate function. Any help would be much appreciated.
-
Sheet Summary Report Builder only shows the system columns
I am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not helpful if I cannot merge together data from columns other than the system columns. Am I doing something wrong?
-
Can multiple users make updates at the same time to a report with a 'has any' 'current user' filter?
Hi, Background: I have multiple Smartsheet files with around 1000 rows that each involves around 20 assigned individuals with various technology literacy. Due to assignees various technology literacy and to maintain the integrity of the Smartsheet file, I've created an individual report per assignee that is filtered by…
-
Dashboard access via link not showing the user as logged in.
So, I am having an issue with my published dashboard. I have embedded a report utilizing the current user function. I have found that when my team accesses the dashboard by manually navigating to it through SmartSheet, the report works perfectly and they are able to view it. However, when they use the published link (which…
-
Is there a way to run a report for T-shirt size
Is there a way to run a report for T-shirt sizes. I need to figure out how many size in S, M, L etc. to do this to order T-shirts.
-
Piechart does not reflect the correct percentage-Showing 100%
My pie chart is linked to a cell that says 25% complete. The pie chart says 25% but has (100%) next to it and shows a whole pie chart. I was hoping it would show only 25% of the pie not the whole pie.
-
Ability for PM's to select which projects they want to receive a status update request e-mail
On an ad-hoc basis I need project managers to be able to select which project(s) they want to receive the status update request so they can update accordingly. Currently In my dashboard I give them access to a separate "project selection" sheet containing the project list (linked in from the master data sheet) and a…
-
Hi! Trying to reorder the grouping of priority on this report to: Highest, High, Medium.
-
No. of sheets updated in report when pointed in the Folder
Hi, May I ask for some advice on this: I am building a KPI portal for our team where manager can see overdue tasks for each resources. Resources are assigned per project so for each projects there are 1 Smartsheet project plan stored in active projects folder. A report created per resource to check overdue task, if sheet…