-
Parent row status formula based on child rows
Roll up formula for status I have this formula (shown below) where I am trying to get the status of the parent row automatically entered based on the child row. I'm not sure if I've stared at this too long and my eyes are crossing, but it's not doing what I want it to do. I think I've listed all the permutations below. 1.…
-
Calculate count based on certain criteria.
Using a helper column to either return a 1 based on certain criteria or greater than 1 based on countif. Then conditional formatting to highlight those that are >1 Current formula that works (partially): =IF(Sit@row = "NA", 1, COUNTIFS([School Name]:[School Name], [School Name]@row, Sit:Sit, Sit@row)) Returns a 1 if the…
-
How to pull data from one sheet column to another sheet column
I need a formula that will extract all data from the column A in sheet A and auto fill it in column B in sheet B when added in the source sheet. Sheet A will have different columns and info than in sheet B, needed only the auto pulling of the data from this one column.
-
Formula Check Box
Hi There, I need help with implementing "Checked" vs "unchecked" symbol into my formula. Online I saw " Checked" and "Unchecked" and that didn't work for me. My formula : =IF([Founder?]@row = "", [First Name]@row + " " + [Last Name]@row + " is a founder of " + [Name of Company]@row + ".", IF([Founder?]@row = "", [First…
-
Quick SUMIFS question - Additional Criteria is Date
Hello, I have a quick question for the formula gurus. I have two sheets, a Roster and Data sheet. My roster sheet is where I want to show the data and the Data sheet is just a collection form. My goal is to display a point total that only pulls points from the last two weeks (14 days). So this is my data sheet. As we can…
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
-
SUMIFS with date range formula question
Greetings, I'm attempting to sum the number of project management hours for the project managers in my function for given points in time to generate a capacity forecast for 2024. I'm currently building a sheet to depict capacity every 2 weeks based on if a date falls between project start and end that will be built off a…
-
Tracking that updates are received from employees
I have created a sheet for employees to provide numeric updates at 10AM, 2PM, and EOD. On a separate sheet, I am trying to create an automatic checklist to ensure all updates are received and that will send reminders if their update is missing. My checklist looks like this: I have used this formula on a checklist for just…
-
Count If AND
Hi! I am trying to build a formula in which I can count an item from a list as long as it meets 2 criteria: 1- Item submission is in JANUARY 2- A dropdown selection is "No" I truly cannot wrap my head around making the right formula so it gives me the appropriate result as I do not know how to build a count IF formula that…
