-
Index Match (?) to two different sheets (unique values)
Hi - I am not sure what is the correct formula to use - I have tried a few and I get errors, so would appreciate some assistance. I have been using Cell Linking to pull in the data, but due to the volume it has become cumbersome and unreliable. I have a master project plan with unique Site IDs in the primary column, and…
-
how to build Gantt with dependencies
Hey, We are R&D company developing large-scale capital equipment. I've built a very detailed Gantt and need help with the central issue of blocking other parallel tasks. We have many different projects on the same machine and machine time is the most valuable asset in the company. How do I block other tasks when they…
-
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…