-
Move a row to a new sheet based on an entry on a separate sheet
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 Employee roster sheet and then move them to a 3rd sheet labeled Offboarding Archive. I am struggling to create a solution for…
-
How to calculate number of days a project is at a certain status?
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 duration. This calculates a predicted end date. I have a column where I can define the project status, these are "In…
-
Using COUNTIFS with AND in Summary Sheet
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
-
Count If Current Week
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 rest. Your help is appreciated.
-
use a reference sheet to gather data for another sheet the rows will differ between 2 sheets
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 completed (SAP completed sheet) going forward in the example. If the student turns in an appeal to the decision then they are…
-
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…