-
COUNTIFS Formula to calculate the number of values in a column with multiple values and parent rows
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, which has a record of the person, their skills and what they are booked to work on. • Each of the people records are assigned…
-
Combining Reports into one Report and Printing
if someone on team wants to get a report that has ways of looking at the same sheet, rather then creating multiple reports that, has smartsheet created a way to consolidate reports into one when sending it out to the team member rather then multiple? Also, has smartsheet found a way to print a report that looks exactly…
-
Why is the "Assigned To" field not an option to group by within my report?
Hello! I created a report with several columns, however, it does not allow me to group by using the assigned to column (setup as a contact list) . Does anyone know why this is happening?
-
Is there any way to enter a Formula into a Report Cell?
I have a sheet that has some weekly inputs. I've created a simplified Report View to only pull in the applicable columns from the most recent weeks/rows of data for the SME to populate. Recently, we had some data in our source information get split into two parts that our Smartsheet still only needs to report on as a…
-
What is the best way to update data between two sheets w/o having to do it manually?
I have a Project Tracking Sheet for all of my team's projects. One of our repeat projects is rollout of the inventory module in our company's primary software. Since we are a shared services group owned by a PE firm, the processes around this implementation are always the same, we just have to track each separately since…
-
Cell-linked dates don't go away when I delete the source
I have a sheet (The Milestone Sheet) that is made up mostly of cells linked to another sheet (The Schedule). The 'start date' column in the Milestone sheet is referencing the 'due date' column in the Schedule. I set the 'duration' column in the Milestone sheet to 0 for every row, which makes the due date the same as the…
-
3+ Levels of Filter Groups
I know I've seen this filter setup before but I cannot seem to recreate. I am trying to layer 3 or more filter groups to attain the desired logic. Is this feasible?
-
Managing Multiple Projects? Project Hub & Workspaces
Hi, I've set up a Project Hub using a template set - in a new Workspace - so that we can see all Projects in one place and, when needed, be able to see Reports for overdue tasks across all Projects rather than having to go to each individual Project for a Report. Now want to move some existing Projects into it, but I see…
-
Why is report not showing on published dashboard?
Below is a photo of two reports that are on a published dashboard. Both have the same permission settings, have been published, and are on the same dashboard. For some reason, the report on the left is not able to show while the report on the right side is able to show. What am I missing?
-
Reports - calculating the gross margin rate
I am using Reports to bring data from multiple sheets in a project, but i need to calculate the project GMR (gross margin rate), how can I do this??