-
Update Cell to show current trend arrow for current month
Hey Community! I have not been able to find a viable solution to what I am trying to create. I have a repository sheet that keeps track of current data. In this sheet, I show trend arrows that show "Sideways," "Up," and "Down" depending on the data entered. Now I'm attempting to figure out how to display this trend arrow…
-
Report Formatting
Hello, I am curious as to methods/best practices for formatting reports. I understand that row level datum have font, fill etc. carried over from the master sheet. What I am struggling with is getting Grouped tabs to have formatting displayed within the report. I have set up a system of grouping starting with the Sheet…
-
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.
-
Dynamic Reporting Linking Filters
I would like to make reports dynamic so that you can link filter options to another sheet. For Control center this would be great because you can have the intake sheet (Where the data lives) drive into the report and populate the results. We would like to see it linked so if you change the data on the intake sheet, the…
