I am try to sum the total weight of a column on a different sheet if the name contains certain text and will be released on a certain date. I am using the below formula but getting #INCORRECT =SUMIFS(…
=SUMIF({CFL Batch Summaries 2021-Present Flower g}, {CFL Batch Summaries 2021-Present Harvest Date}, YEAR(@cell) = 2021) I am trying to use this formula to sum the total grams if the harvest date was …
I would like to add a formula to the sheet that shows a Pass or a Fail depending on three other columns. If Mold Present column say "No" & the Seeds per 100g column says "None" or & the Foreign Matter…
I have a sheet used for grading our product. There is a final score for each product out of 36. I would like to use a formula that uses the final score to give the product a "Grade". 0-12 = C, 13-23 =…
I have 2 sheets. Sheet one is a grading sheet that goes over appearance, aroma, feel ect. of a production lot. Sheet two is a stock list showing all production lots. Both sheets have the primary colum…
I have many sheets that collect different data on production lots and one sheet that show the most important data sets from those sheets. All the lots have an ID number that is used on all the sheets.…
Hello, I would like to take the current usage number of a product and depending on a trend line symbol either return the current usage number, add 10% to it or minus 10% from it. =IF([Trend Line]@row …
I want to use a formula to get a sum of a weight from a list on a separate sheet that matches a certain name and has a ready date that falls within a certain month. =SUMIFS({CFL & VL Product Stock Lis…