-
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…
-
New to Smartsheet - Setting alerts once status has changed
Hi all, I hope you are all doing well. I have tried to incorporate Smartsheet into my daily workings and hope you may be able to help. Seemingly, Excel is far easier when setting rules, but with automation needed I decided to use Smartsheet. Currently, I have a project on hold sheet which records all projects that are…
-
Pull information from report to sheet
Hello, I have a template that my team uses for data collection each time we get a new lot of diagnostic tests we need to quality check. In one folder, "data collection forms" there are many sheets, as each lot gets it's own sheet. New lots are tested every day, so the sheets in this folder are constantly being added to. We…
-
Charting with dates using the data on the Report Item
The labels for my date are weird. How do I fix? The information under each Due dates are file names.