-
IF Formula Question
Hi there, I am kind of new to SS formulas and I am trying to create a function that adds an amount to a column IF that column is a certain deal type. The columns that I need the addition to are labeled "Development WAG $" and "Implementation Costs $". IF the "Deal Type" column has "Lease/ Purchase" I need the $350,000 to…
-
Sheet Summary Formula versus Sheet/Report Filtering
Hi all, I've been scratching my head on this for a while and I can't resolve why the filtering I do on a sheet/report is not matching my formula on a sheet (upon which the report is based on). Here it goes: I have an intake sheet for my projects that when a PM creates a project via Control Centre, it spits out the expected…
-
Show Reports' sheet sources for Workspace Sharing Report
In Workspace folder, when you right click, you can download workspace sharing report. With this, you can view list of dashboards, grids, and reports in the workspace. Would it be possible to get information about which grids were used in a reports?
-
Can I create a report with mutiple filters for a dashboard?
I created a dashboard that display the issue, report date, number of weeks and wireless chipset, I would like to have a filter per month. In other words, I want the capability to add 12 filters (1 per month) and apply the filter once the month is done to show all activity at the dashboard, is that possible or I need to…
-
How can I create a quarterly dashboard?
Currently I have an annual dashboard created by mostly pulling multiple reports that primarily uses sheet summary data. How can I pull quarterly reports using the dates 10/1/22-1/31/23 to filter my reports? Keeping in mind that I can't filter by columns because I am using sheet summary to build my reports. Here are…
-
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…