-
Week Commencing Date
Does anyone have a formula I could use to work out the week commencing date for a date field where Monday is the start of the week?
-
How to count dates in a column? INVALID DATATYPE error
I want to count how many dates in a column called "Completed" occur in the month of January. Using this formula =COUNTIF([Completed]:[Completed], MONTH(@cell) = 1) returns INVALID DATATYPE whether I use it in a cell on the sheet or in a sheet summary field or on a separate metric sheet with the formula referencing the…
-
Formula to Count multiple text values in a range
I have 2 columns/ranges. I need to count if range1 is value text1 and range2 has values text2, and text3, and text4. This formula works so far =COUNTIFS([Range1]:[Range1], "Text1", [Range2]:[Range2], "Text2") However things get wonky when I wan to add more text values to Range 2. So it would kinda look like below. But…
-
COUNTIFS Using both AND and OR
Hi, Looking for a bit of help trying to utilize the COUNTIFs function to filter based on a specific value for one variable and between two other values for the other variable. In the sample table below, I'm looking to get a count where the TASTE is PREFERRED and the ALLERGIES is either YES or UNKNOWN. I've tried the below…
-
HELP with formula - Countifs which counts total with 3 criteria met
I can get two criteria to work with the first part of this formula but when I add the third condition I get an error. =COUNTIFS({Return Mail Deep Dive Can Remail}, "Yes", ({Return Mail Deep Nixie Reason}, HAS(@cell, [Primary Column]@row), ({Return Mail Deep Dive Grouped Findings}, HAS(@cell, [Grouped Findings]@row)))) Can…
-
Is there a way to have each row calculate the duration?
Hello! I am trying to make a travel for work log where when someone enters their dates they are traveling for work, it automatically calculates it in the travel for work days column. I like how the below screen capture is set up, I would just like to find a way to automate it without having to enter in how many days they…
-
Index/Match Help
Hi - I have a sheet called "Source Data" which has a list of roles in Column A and the description of the Role in Column B. In another sheet "Worksuite Requests" I want the description from the Source Data to pull in if the role name is a match. I can't quite get the formula:
-
VLOOKUP issue
I am trying to pull totals from my 2023 sheet into my 2024 sheet. The totals I am pulling are in a different column but same row as where I want them, so I decided to use VLOOKUP. 2023 Sheet: 2024 Sheet: I want 'Total 2023' to be pulled and placed in 'Previous Years Total' for each corresponding row. My formula:…
-
Poor Man's Datamesh
Prior to getting Datamesh, I devised a solution to transfer data from one page to another, without having matching columns. This process uses an intermediary sheet. It's kind of a pain to set up, but it works well and requires little to no maintenance. I still find some very small use cases where this comes in handy.…
-
How to count different text values listed in a column
I have 2 columns/ranges. I need to count if range1 is value text1 and range2 has values text2, and text3, and text4. This formula works so far =COUNTIFS([Range1]:[Range1], "Text1", [Range2]:[Range2], "Text2") However things get wonky when I wan to add more text values to Range 2. So it would kinda look like below. But…
