-
Formula to track projects running per quarter
Hi, I have a table with a list of projects (project ID available) and related columns with Start Date and End Date each project (column in date format). I want to be able to create reports and display metrics in the Dashboard showing up how many active projects I have running during a given quarter (considering Start…
-
Date Column Not Working
When I enter dates into the column titled "Start Date" or "End Date", the data disappears from the cell.
-
Count PM name + % completed based on 20%, 50% and 90%
I tried using the below formular but was not able to get the output. =COUNTIFS(PM:PM, "Cameron Kang", [% Complete]:[% Complete], "20%;50%;90%")
-
Average If Formula
Hi Smartsheet Community! I have what I think is a pretty simple cross-sheet formula question. I have created a survey that asks users to respond to each question with a 1-5 answer (1 lowest - 5 highest). I am trying to use an AVERAGEIF formula to average each answer IF the answer was submitted in a certain month and IF it…
-
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…
