-
Dynamic Report Filters
I don't think this is a feature, but it would be extremely helpful if it was. Let me share the details. We often use the method of creating a template of something, lets say a sheet, two reports, and a dashboard. We keep these four in a folder, and if we need a new one, we'll copy the folder to the correct location, rename…
-
Resource Management Analytics - Report by User, Utilization/Allocation, and Project
We'd like the ability to create a Utilization Report that groups by Name and then shows the Project Allocation %. We have the ability to group by Team Member but we cannot "Then Group By" Project. We'd like to see the percentage allocation as a report in Resource Management by the Resource Allocation Plan from SmartSheet.…
-
Dynamic Report Scope not updating properly
I added a few reports to the Dynamic Report scope within our Blueprint in Control Center. After a new project was provisioned, rather than updating the source sheets to what I had selected, the previous selections (entire workspace and sheets) were still listed. The documentation notes say that this would be overwritten…
-
Combining multiple sheet Data in 1 report against common primary ID
Hello folks! I'm working to build a series of reports for different stakeholder groups where the goals are to: Gather specific pieces of data (columns) from multiple sheets (which all share the same primary IDs) Combine data from each sheet into unique rows for each primary ID Allow the stakeholders to edit the data (and…
-
Edit specific sheet columns through a report
Hi there, In the past I was able to create a report and publish it in a way so that people with the link could edit the sheet rows through the report. I'm trying to replicate that again today and I don't see (or remember) how to accomplish that. Any clues would be greatly appreciated. Thanks, ~Anelise.
-
Way to use grouping in reports with a multiselect column
Is there a way to group a report using a multiselect column? I have spent a while going thru the community posts going back to when the grouping in reports was released and see that this is something that has been asked about repeatedly with no solution or real work around. We have some sheets that require this…
-
Multi-Tier control center - Portfolio Workapps
Today WorkAPPs does not support Multi-Tier Control center solutions. If you would like to use Portfolio Workapps and you have a muli-tier solution please vote.
-
Roll-up multiple projects by "assigned to" and NOT TO BE A REPORT??
Hello beautiful community of SmartSheets, The client wants to use the card view of smartsheets but not in smartsheets itself but via Microsoft Teams, which is a great integration platform, the problem is that when you integrate a report via teams, is "View Only" so the client can't move the cards around or check tasks that…
-
Use of Smartsheet for Preventive maintenance program
Hello, I looked at several tool to manage our maintenance program. We have several equipments with subcategory that I can organize with Parent and children relationship. I have a due date and a frequency of operation (industrial application: Replace hydraulic oil, replace wear plate etc). My plan: create 2018 maintenance…
-
How to count tasks across all sheets in a workspace
I have a master metrics sheet that I am using. I'd like to be able to count tasks by assigned to across all sheets in a workspace. The goal is to have this formula work if/when any new sheet is added to the workspace. Reports are not really working for me because my assigned to column is a multi-select column. I don't see…