-
Index Match Showing Incorrect Amounts - Formula when there is no information to pull
Hello! I am stuck on the INDEX MATCH pulling incorrect amounts when I reference another sheet. It will work for some cells, but not others. I am thinking since the parent sheet doesn't have all the line item costs for each store such as "Shelving" or "IT/LP", that could be the issue, but not all stores will have those…
-
Manpower Summation from Schedule
Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", "piping subcontractor" etc. My schedule is about 1500 lines long with lots of concurrent activities. My…
-
How to get realistic timeline of the project considering the resource allocated
Hi all, First time using smartsheet and haven't been able to figure it out. I searched on this forum and seems like back in the days people had similar issues. Not sure if it's been resolved or not. Here is the issue: I have contractors that are helping with the project. I need to get a realistic timeline to know when…
-
How to count children rows with multiple criteria
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status". Each parent row is a different year and beneath each year are cases IDs (these are in the caseregnum column). The cases are categorized into "general" and "special" (this is the type of…
-
Master Roll-Up for multiple project sheets
I am reviewing the Construction and Facilities Management template set provided by Smartsheet. I only have a Team account for now. The template comes with 2 sheets for Projects. In the Master Roll-Up sheet, you can see the formulas used to pull the info from the 2 Project sheets. Question: Do I have to manually update the…
-
Connect sheets without manual cell linking
I have a project roadmap (activity name, start date, end date, etc) and then a separate sheet where we want to pull from the existing project roadmap. With roadmaps, information is always changing or being added and I want the separate sheet to be able to live update when changes are made. I don't think an automated…
-
Actual % bar in Gantt view which is based on budget mhrs in Project Plan
Hi there If I'm correct, Smartsheet only provide the "Time Duration (i.e. Days)" as the basis for Porgress Measurement in Project Plan. It's good in a way, but not that professional. For now, I have to set up a column for uploading the budget mhrs for each tasks (say 200 to 300 tasks for a classic project) and use it as…
-
Manual Workflow Trigger for Time Base Automations
Hello all, I was setting up a Workflow to trigger based on a condition at a certain time of day. It did not work, which is fine it was a test, but now in order to run that same test again, I have to move the trigger forward an hour and wait for it to reach that time. (Function is to clear a checkbox daily) Since I am…
-
Creating a Master Project List and Dashboard
Hello, I would like some help in designing a Master Project List, and a Master Project Executive Summary Dashboard. We have a Roadmap that contains each functional area's main projects/initiatives. Is there a way I can build a formula to have all the information from each road map combined into one Master Roadmap... Which…