-
Using most recently added row to populate dashboard
Hi - I'm building a dashboard for project reporting, and need the most recently updated row from my data sheet to be used to populate the Metric Widgets. The data needs to come from a sheet rather than a report as I want to display the data split out into areas, not all in one place. I've done a lot of reading, and so far…
-
Tracking Employee Effort Across 170 Projects
I have a little experience using Smartsheet in my previous role at FSU and am now trying to help them adapt to some (unforeseen at the time) scaling and relational issues on the sheet/form I built. Specifically, this tool has been implemented as a way to track effort/time on a large 5 year federal contract. Our current…
-
I would like to compare week number with column name
I have a column for each work week of the year (1 to 53). I would like to append the value of HC Plan on its respective column, based on Start Week and End Week. For example, if a project starts on week 1 and end on week 2, I need to append a Head Count of 5 to the columns of Work Week 1 and 2, to keep track of HC needed…
-
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…
-
Drag & Drop Emails from Outlook to Smartsheet in Chrome & Email is Deleted from Outlook
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone. I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies and uploads to Smartsheet without deleting it from Outlook. * Windows 10 Pro for…
-
Hierarchical Workspaces and/or More Sharing Options
I currently have an issue where I would like to share capabilities for certain folders to some and it doesn't seem like it has the capability to do that. Currently, I can share the overall workspace with everyone or certain sheets/reports/dashboards within the folders, but it is not easy to get a natural hierarchy with…
-
How to show budget only for one out of several years budget plan?
Hi dear community, i build up a project plan, and its associated budget, wich is running over several years. Now, I would need to show the total budget per year (e.g. 2023) and i was using the following filter in my report. The problem i have is that some Work Packages are running over 2 or years and i'm not 100% sure how…
-
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…
-
Averaging RGB balls
I'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue balls on the Children rows...make sense? Help would be much appreciated, screen shot…
-
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…
