I have a column named "Ready". I want to change the color of the cell in that column to green if the cells in these five other columns all contain "Located" or "Clear". I've figured out how to check a…
I have created a solution for our staff to reserve desks when they are coming in to the office. They select the desk, the day and if they want it for the AM, PM or All Day. By using formulas and helpe…
I have a sheet where I would like a [Next Anniversary] column to display and automatically update the next upcoming anniversary of [Hire Date]. I don't want the [Next Anniversary] column to display th…
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…