-
How can I collect a prior score based on 2 criteria?
We do 5S Audits of our building and I need to be able to pull the prior two scores of the same area. It worked for a while but then all of a sudden it started showing the Divide by Zero Error even though there are prior scores. Prior Score Formula: We got the prior 5S Date to pull but for some reason, we can't pull the…
-
VLOOKUP or INDEX MATCH Referencing Another Sheet
I would like to pull "Type" from a different sheet by matching the Project #. I've used both INDEX MATCH and VLOOKUP formulas which has worked well! Here are the formulas: =INDEX({Program Intake Form Range 1}, MATCH([Project #]#, {Program Intake Form Range 2}, 0)) =VLOOKUP([Project #]#, {Program Intake Form Range 2}, 5,…
-
Formula using a checkbox column to get Yes/No
Greetings, I'm trying to write a formula that will give me a yes or no in a new column when criteria is meet. For example, if in Services Needed column contains HVAC, Lock/Unlock, Lighting Only AND HVAC Completed, Lock/Unlock Completed, Lighting Only Completed are all checked then it will equal Yes in all services done?…
-
Uncheck Box
I have a formula that says IF(Date@row<TODAY(-14),1,0), to add a checkmark, but how do I add a formula that says once a next recurring date has been added to remove this checkmark.
-
INDEX/MATCH for Multiple Criteria to create single row
Hi all, and thanks in advance for helping, it is greatly appreciated. This was a solved problem, until it was determined that each Release and the stages needed to be on 1 line, rather than 1 for the releases and then the 7 phases below. The first sheet in my data file which I am linking from. This sheet is owned by…
-
#NO MATCH error on a Sheet Summary Formula
Hello, I'm guessing the problem is because the field I'm referencing is a formula and not a value, but would appreciate suggestions on how to handle this. I want a sheet summary formula to return how many Variances exist for each VarianceCategory, so I can use this information in a report. I've listed the formulas that I'm…
-
Manpower Loading Schedule
I am trying to create a Project(schedule) that has a manpower loading functions. I am almost there but I am stuck with trying to figure out how to see how many crew members I have on a certain days by suming them up. For example I would like to have a list of dates and then show how many crew members working on those…
-
Nested Formula Help
I am trying to use this formula and it is not working. Does anyone have a suggestion on how to fix? =IF(AND(ISNUMBER(Results@row, ISBLANK([Results Symbol]@row, Results@row > [Conventional Spec]@row))), 1, 0)
-
Reference Comment in Formulas
Please add functionality to address comments via formula, such as =countif([Comments]@row, "No Change") to simply count how often in a row a project is listed as "No Change" or how often something is commented on with =count([Comments]@row). This would add functionality for tracking KPIs and Leading Indicators which is…
-
How do I best link a list of entries in one column to an entry in another column?
What I'm looking for is the ability to create a list column called "Product" and have another column called "Options" which would have another list of entries filtered based on the selection in the "Product" column. Any help would be greatly appreciated.