-
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…
-
SUMIF between dates
Hi Community! I'm just trying total amount of "Booked" from Mon to Sat for the last couple weeks. Any help would be appreciated. Thank you...
-
Extract Date from Date and Time in Date Column
I have data pulled into a date column in this format: 6/1/2022 7:30:57 AM This is not a system-generated field. I need the date only in another date column. Thanks for any help! Lori Flanigan
-
How to link a column to a different sheet that auto populates when new rows are added?
I'm trying to do a workaround to adding multiple rows from the same form. I created a new sheet that has columns for requests 1-10. I want to pull certain columns from that sheet to move to a new sheet and then I can use a workflow to transfer that to my main sheet. I've created an ID column that autogenerates a number as…