Hello, My company has a sheet titled active employee roster which has every employee in the company. We are trying to create a new Offboarding sheet that will then find the employee on the Active Empl…
Hi all, I am looking for a way to calculate the number of days a project is on hold based on a change of status. In my theoretical planner, I set a project start date and input an estimated project du…
Current Formula is for # Enrolled =COUNTIFS(Enrolled:Enrolled, 1, [Course Name]:[Course Name], "Name of Course") I need a formula for Enrolled AND # Late Status Red X
Hi Everyone, I have some daily data with dates and I want to get the week to date numbers off that data (Monday - Sunday of current week). I know countif is needed but I'm not sure how to go thru the …
Hi All, I've been pulling my hair out and I'm hoping someone has advice. Bing Copilot is running me in circles because it doesn't understand. I have a sheet with SAP appeals that all steps have been c…
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…
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 subm…
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 …
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?
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: =COUNT…
