-
How do I do a min/max output based upon a specific criteria?
So I think I've come close to this in the area of indexing, matching, etc., but I can't quite get the formula to work the correct way. I have a sheet setup to where it calculates the average number of days that specific jobs have been open and working within several different groups in my organization. Each organization…
-
Formula adding previous days
My goal is to have a summary sheet that shows by day how many tasks each worker completed and how many they did not. The intake sheet is set up for them to enter the date when they input data so if they are on vacation or just don't do it, no date is present. This is my summary sheet to add up done and undone checkboxes…
-
Multiple Contacts and effort total
Hello, I am tracking tasks with an Assigned To column and Effort column. My original sheet required repeating the same task and assigning to each individual who would perform that task, and then using the Sum(Children()) to get the total effort for all child tasks. I would like to allow the Assigned To column to use…
-
Duplicating sheets deleting certain columns and team distribution via viewer mode
All, Thank you for your time. I am trying to accomplish a few things simultaneously: I have a master account sheet that I want to send out to the rest of my team but I want to do it in the following way: Send them a duplicate sheet with certain financial columns omitted As I update the master sheet, the sheet that is sent…
-
Combining two IF functions
Hello! I am trying to make is a formula that says "If there is a complete date then calculate the # of days that that task took from approval to completion. If complete date is blank then calculate how many days has passed since the approval date". I have two formulas that work independently but I can't figure out how to…
-
SumIF/CountIF not Working
Help please... why is it that my formula is returning a "0" zalue in Timecard Completed1 field when it should technically return a "1"? Formula being used: =SUMIF(($PPE$10:$PPE$172), $PPE@row, ([Timecard Complete Helper]$10:[Timecard Complete Helper]$172)) I'm trying to get the 'Timecard Completed' column to count the…
-
Count of Multi Select Options Across Entire Sheet
I can find some reference to this that others have asked but it seems slightly different then what I'm looking at. Consider the following: Column: Type of Issue A, B, C A, B A, D A, C, D C, D I'm looking to place a count of each of the items above on a dashboard across the entire sheet. Any insight would be appreciated John
-
Issues with CONTAINS using Cross Sheet Reference
Hello, I've created a COUNTIFS formula referencing another sheet. Each section of the COUNTIFS references the same sheet so that isn't the issue I believe. Everything works up until the CONTAINS portion. Is there an error with my syntax? =COUNTIFS({Status}, New1, {GSP Category}, "New GSP Onboarding", CONTAINS("Onboarding",…
-
COUNTIFS in different sheet totaling values from two columns
Hey there, I would appreciate some help. I've tried multiple formulas and can't get it right and hope you can help. I have a summary sheet which i am referencing a sheet to gather the total active projects for a department. There is a dept column and a status column. I created Dept_Ref where both those columns are…
-
SUM entries MTD for each day and each month
I have a sheet with the date on each row starting 07/01/2021 through the end of the fiscal year, 06/30/2022. I need the month to date sum on each row. I sum each date with the date before but I have to manually change the formula at the end of each month. Is there a way to do this automatically so I don't have to restart…