-
Formula to count the overdue task with Assigned Person
To brief, need a formula to know the overdue count for each assigned persons. With these details, will help show a chart in dashboard
-
Calculate Total % Complete Checked Boxes of all Parent and Child Tasks
Project: I have a massive checklist we use for event planning (700+ rows!) and want to be able to know how far along in the planning we are percentage wise for one particular event. Goal: I want the Parent row %s to be the total percentage complete of all their Children tasks. The parent row is setup as an event planning…
-
Is there a way to tell what sheet a form is connected to?
I've been sent a form to potentially edit but the requestor does not know what sheet it is connected to. Is there a way to figure out what sheet a form is connected to if you do not already know? I'm asking around but got curious if there was a way to figure out just using Smartsheet. Thank you!
-
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…
