-
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…
-
Reports - How do I create a report to give me the flag column?
I created a sheet that has a Flag column. I built a formula in the flag column to indicate when a number is within a range. =IF([Total of Buckets Weighed]@row < 25, 1, IF([Total of Buckets Weighed]@row > 35, 1, 0)) - This formula works fine. The problem is when I am creating a report and the flag column doesn't appear with…
-
Is there a way to pre-populate past survey responses by user?
I have a feedback survey(form) that users fill out a few times a week and I was wondering if there is a way to have their responses pre-load from the last time they answered. For example, say they fill out the survey three times a week and nothing has changed over the course of the week and they want to submit the same…
-
Calendar view using the REPORT feature.
I like using the calendar view when using the report feature. My issue is that when I click on the item in calendar view (from the report), it shows me ALL columns from the source sheet. I would like to see ONLY the columns that are selected from the report builder. I am using the report feature to pare down the amount of…