-
Index Match Formula
I am trying to use sheet cross-reference formulas to pull data from one sheet to another. I have a "Roster" Sheet that lists the names of new employees who have many different job codes. I want to only pull the Last Names, First names of employees that have specific job titles. How can I use the index match formula to pull…
-
Is there a formula to get the average of star ratings?
I have a column that is only star ratings. I am trying to the get the average rating of the entire column in a sheet summary field. I tried to just do the average formula for the column and got the #DIVIDE BY ZERO error. Is there a formula that can calculate the average without having to create a helper column to translate…
-
IF(IS BLANK) - Multiple yes no criteria
I am trying to find a way to have this function look at 4 different cells and if any of them are not blank, it want it it say, "yes." If they are all blank, i want it to say, "no." I guess I need 4 of these strung together with OR. But I can't make it work: =IF(ISBLANK([Outstanding Audit]@row), "No", "Yes")
-
Workflow and/or Formula for tallying daily asset inspection issues
We have daily asset inspections that are submitted via a form and I'd like to: Create a daily Workflow that will send only the assets that had an inspection issue on that date, as well as the issue description. (Columns are: Asset, inspection yes/no questions, and description of issue) . Rows are each date an asset…
-
Cost Formula using multiple criteria
I have been beating my brain trying to make this formula work. Any help is appreciated. I have two sheets, the Sample Sheet and the Sample Pricing Sheet. I want to be able to fill in the customer with the pricing options and product(s), then have the product cost autofill under the correct column(s). The products have a…
-
Count columns based on drop down select
I want to be able to have a sheet that lets me select items we make from a drop down list then check the components needs to make that item. Then have it multiply the materials needs by the number we want to fabricate and total the needed materials. After that I would like to have the sheet check our on hand materials from…
-
CAPTURE VALUES FROM ONE SHEET AND POPULATE ON ANOTHER BASED ON A KEYWORD
Hi, I am trying to capture equipment number, year, make and model from my main sheet based on the status "available for transfer" and bring those values over to my calculation sheet to display on my dashboard. Below is what the main sheet looks like that I want to pull those values over to my other sheet based on the…
-
Can I use a helper cell to house the year in these formulas?
I'm wondering if I can have a helper column/cell that houses the year instead of including 2023 in all of my formulas (we're talking over a thousand cells). I want to have a helper cell that has 2023 (or 1/1/2023 if it needs to be date format), so that when it comes time to update everything at year-end, I can just change…
-
Cross Sheet JOIN/COLLECT/INDEX/MATCH conundrum.
Hi all, going a bit crazy trying multiple variants on these formulae to get my desired outcome. Hoping someone can put me out of my misery. In my source sheet I have columns and rows like this: In my destination sheet I want to pull in a list of Projects from the source sheet that are Flagged "Yes". Like so. It seems so…
-
Sum Checked Boxes referencing another sheet
Hello, I would like to get a formula that sums checked boxes only and also give me the count based on project status. This "Metric Sheet" refers to a regular sheet assigned by team member.
