-
I need help with SUMIFS
I have a sheet that has is called 2023 E&T MEDIA PLAN. It has PRODUCT CATEGORY and COST. I'm trying to add the cost of all the product categories. For Example, INTRAORAL SCANNER is a PRODUCT CATEGORY =SUMIF(2023 E&T MEDIA PLAN : PRODUCT CATEGORY, "INTRAORAL SCANNER", 2023 E&T MEDIA PLAN : COST, <0) What am I doing wrong?
-
Simple formula to increase the date by 12 months, or 1 year less one day
Hello, I have played with this until my brain is numb. =DATE(YEAR(Entry@row) + 1, MONTH(Entry@row), DAY(Entry@row) -1)
-
Combining IF and IF AND Formulas
I have three formulas below that work as individual formulas. I am trying to combine them in my Status column into one formula so my cell automatically updates based on the percent shown in the % complete cell. I thought it should be =IF([% Complete]@row = 0, "Not Started"), IF(AND([% Complete]@row > 0.01, [% Complete]@row…
-
Is there a way to stack data from multiple columns into one and sort by date?
I am trying to plan when each part of the order is supposed to be made in the columns "XLS". I have formatted the data below how I want it in the columns Customer to Inoculation Dates. The data I want to format is from Customer (original) to Quantity 2 I am thinking INDEX and MATCH, but I am completely stumped. I have…
-
Auto-Number the next column within one row
Hello, I have created a sheet that I will use to track scheduling in Construction. I have attached 2 photos. I want to have an automated number/date system like the excel picture shows. Can anyone assist in what formula or strategy I need to implement? Thank You
-
Using Index/Match to fill out document
I am trying to use INDEX/MATCH functions to gather the items and quantities to go onto a printed document. I’ve gotten as far as this function: =INDEX({InventoryIndex}, MATCH($[IndexKey created with a different function]@row, {column in the index with all the index keys}, 0)) My question: Is there a way for the function to…
-
#Invalid Data Type
Hello, I have a formula in my sheet summary that was working until recently. For some reason the formula is no longer able to count the months or years in the sheet. I also receive the error when I remove the [Current Month]# from the formula and try putting "11". Does anyone have any recommendations or see anything wrong…
-
Combine (Concatenate) Text or Values from Two or More Cells into Dropdown List Column
Is it possible to Combine (Concatenate) Text or Values from Two or More Cells into Dropdown List Column (allow multiple values per cell) and have it display as separate entries? I am aware of how to combine using spaces, dashes, commas..I just want it to have this view (see picture).
-
How to write a formula based on 3,6,9 months from current date, using G/R/Y/G symbols?
Hi, I am trying to write a formula that uses the gray, green, yellow, red symbols to show how close we are getting to something expiring. If the Patent has not yet been filed (date is blank) this would be the gray symbol. If it has been filed and is under 6 months old, green; if it is between 6 months - 9 months from the…
-
Program Health Formula
Hi everyone. I am struggling to figure out a formula for program health that doesnt come back as #UNPARSABLE Green: Status column is "Completed" or the End Date is 30 days out or further. Yellow: Status column is "In Progress" and the End Date is within the next 30 days. Red: Status column is "In Progress" and the End Date…
