-
Manpower Resource Loaded Schedule - SUMIFS Formula Help Needed
Hello, I have created a resource loaded schedule based on manpower in Smartsheets. I have a separate "Metrics Calculation" sheet where I am calculating the manpower per day and per department. However, I am having trouble performing the calculation using a SUMIFS function. Once this number is calculated, I want to roll…
-
How to autopopulate % Complete based off of other cells entry
Hello, I am trying to autopopulate % complete based off of other cells YES/NO entries in the sheet. I have 5 criteria to determine if we get to 100% Completion or not: Columns: Paperwork Received - YES (add 20%) NO (add 0%) Samples Received - - YES (add 20%) NO (add 0%) HPCL Received - YES (add 20%) NO (add 0%) Hold…
-
Results and expressing as percentage
In my forms, I have several questions that can result as either PASS, FAIL or N/A. I want to express only the FAIL cells as a percentage over the entire row results. I've been using this formula: =COUNTIF(CellName1@row:CellName2@row, CONTAINS("PASS", @cell)) / 7 The only way I've been able to make this work is by counting…
-
Getting a NO MATCH when using Index/Match in a formula
This has been working very well on previous sheets. This is a Titration Log and it varies per plant and therefore very tailored to their line and parameters. In the steel business - so you'll see substrate as to what I am matching. I have a column that does the look up and returns "red" if out of spec. The ALUM formula is…
-
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…
-
INDEX(MATCH) or JOIN(COLLECT)?
When we first started using Smartsheet, the rep who handled our "Launch Package" created the following formula. =IFERROR(IFERROR(INDEX({SupplierItemNumber-AL}, MATCH($[Our Part Number]@row, {OurPN-AL}, 0)), INDEX({SupplierItemNumber-MZ}, MATCH($[Our Part Number]@row, {OurPN-MZ}, 0))), "ERROR - CHECK PART#") It searches two…
-
Building contingency into project plans
What is the best way to manage tasks that have a high degree of uncertainty in the duration? An example might be resolving a design problem – sometimes they are quick, sometimes they take a while. A previous software we used, allowed you to put in a best case and worst-case estimate for each task – effectively adding…
-
Sheet to Sheet with Parent Rows
I have created a sheet that when a check box is marked it moves the entire row to another sheet. I was wondering if there is a way that when the row moves to another sheet if I can have it populate the information under a parent row? Example my Scheduling sheet moves the row to my Machine sheet. My scheduling sheet I make…
-
Timestamping
Hello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Create SUMIFS formula with a contact criteria in a multiple contacts range
Hi, I am looking for the right way to build my formula that makes a sum of a number column with a contact criteria in a multiple contacts range. Example: =SUMIFS({numberRange with hours}; {Criteria Range with multiple contacts}; Contact Name; {Range with Statuscode}; "In Progress") Check also the screenshot below. If I…
