-
Count if
Hi I'm wondering if someone could assist me. I writing a count if for a column and it isn't counting the item if there is more than one answer in a row. Example would be =Countif([Case Type]:[Case Type], ="Birth Certificate". If you see below where Birth Certificate and SSI are in the same row, my formula is not counting…
-
formula not working
hi Team, I have two date columns and based on date column final status column. and applying simple formula . if (col1<=col2, "Green","Red") but in case end user enter NA in both the column, output is "Green" and col1 is NA and col2 is N/A then output is "Red".. why..? please suggest .
-
How would I get my VLOOKUP to return multiple Values?
Is there a way to get my VLOOKUP to return multiple values? Current Formula: =IF(ISBLANK([(REC) - Project Number]@row), "Part Number", IFERROR(VLOOKUP([(REC) - Project Number]@row, {QC1}, 3, false), "Part Number")) In my example image, there are 5 Project Numbers with unique Dates / Part Numbers / Part Descriptions / PO…
-
IFERROR Formula
Hi All, Hope you're keeping well. I've recently started playing with IFERROR's and updating some existing sheets. I have a sheet that reports with each row being a week of the year. Many of the formulas for "Rows in the future" or in some case, "Rows in the Past" return DIV0 or similar errors which I'm trying to eliminate.…
-
How to get the dates for every "Monday" in a month
I am working on a Flex schedule tracking sheet for employees that would like to go into the office for set days during the month. The best way I can think to do this in a form is to allow the employee to select the days of the week they would like to work in the office from a Multi-Select dropdown. ie- Monday, Wednesday,…
-
if / or / contains
Hello, I need some help with a formula using if / or / contains. If the cell contains "card", return the words "Business Card", or if the cell contains "page, return the words "1/4 Page", otherwise keep blank. I can get part way there: =IF(CONTAINS("business", [Spring / Summer Newsletter Ad Size]@row), "Business Card", "")…
-
Trying to pull unique values from another sheet's column
Just as the title says, I'm trying to build a solution that parses and lists the "Region Name" field in a sheet, so it can build another list based on "Regional Partner". Basically, I'm trying to build an abstract method of building a list of regions and their associated regional partners. Why? Because these 2 fields seems…
-
Weekly requests Received & Sent
Hello! I am trying trying to come up with a formula for a Sheet Summary field that can output the number of received requests and number of sent requests over the course of the current week for each member of my team. I have a [Received Date] Column and a [Date Sent] Column where the dates are inputted but I just need the…
-
Is there a way to write a formula to uncheck the box in one column IF another column has a checkmark
I am wondering if there is a simple formula that will uncheck a box in one column if a second column is checked. I am sure it is a really easy formula but I am drawing a blank. Thanks.
-
How to do countif/contains formula
I have a sheet that has drop-down multi-select columns. I am trying to create a metrics sheet that shows the number of people that selected a specific drop-down menu item. For example: Choose 3 favorite foods: burgers, pizza, sushi, pasta, chicken They selected: Burgers Pizza Sushi But I want to know how many people…