-
is there a way to generate incremental number to name that is listed more than once
I have a store number; each store has a monthly store visit date. I am looking to use the store number and add the number to show how many previous visits there were before. I have a formula to add an incremental number, but it did not represent the number for the specific store's visit. Is there a formula that can get me…
-
Count if Not Formula
I am capturing data from a form that collects data around car seat distribution and what county we distribute to. I want to capture when there is a date range for the date of distribution and the submitter is not from the following 5 counties: Haywood, Buncombe, Madison, Henderson and McDowell. I keep getting an…
-
Counting specific values in multi select cells
Hello! I've read through several different posts about which formula to use to count specific text values in a multi-select cell however, I'm still getting errors on my end. I'm trying to get a count for each virtual event my team has selected. The formulas I have tried are: =COUNTIF([Virtual Event]:[Virtual Event],…
-
Count number of each day of the week occur in a certain month
I want to type the month/year in a cell and have formulas to tell me how many Sundays, Mondays, Tuesdays etc are in that month. I'm currently entering that manually. Is there a way?
-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…
-
Chaining "If" Functions
Hello, I'm attempting to capture if (4) columns contain DB01-DB12, and if a cell contains DB1-DB12 then it returns ONLY DB01-DB12 (see below for reference). I managed a formula for Db01 and DB02 but once I try DB03 I get an error (likely because it registers as IF False). Is there a better way to string multiple…
-
INDEX COLLECT across a range
Reposting now that I have a better understanding of my problem. I am a bit stumped and looking for a little help. I have a forecast sheet with a form where the user has to submit their monthly forecasts for the quarters across five subject areas. I have a column for each quarter and each subject area, 20 columns is my…
-
Need Help With COUNTIFS OR Formula.
=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], "In Progress") That formula is to count the number of cells that have "Now (1/1/24-5/31/24)" in the Timeline Prioritization column while also have "In Progress" in the System Status column. Based on the…
-
Return to a wrong value when using index and match formulas
When using the index and match formulas, the return value was correct before but when I refresh the search sheet then the final result start to be wrong and the same even the search value is not the same. Can anyone help to check and advice? Here is an example: formulas =INDEX({MMX-FOR PROTO TRACKER Range 1},…
-
Grab digits to the right of the "-"
I'm trying to separate the Area-Route column. For Area I'm using =LEFT([Area-Route]@row, FIND("-", [Area-Route]@row) - 1) and this seems to work fine. For the Route I'm using =RIGHT([Area-Route]@row, FIND("-", [Area-Route]@row) + 1) but this doesn't seem to work. You can see that their could be zero digits to the right of…
