-
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…
-
Status Ball change 30 days after start date
Hello! I am assisting a colleague with a smartsheet issue. She would like the status ball to become yellow when 30 days have past the RFT start date and red when 60 days have past the RFT start date. I can't seem to figure it out and I thought I'd see if anyone can help while I continue to try and figure this out. Thanks…
-
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…
