-
Countif function
Ok so...trying to get this data from the source file below which feeds into the computation sheet below it to represent 3 graphs in my dashboard (Click total, Unique click, Opened) for each previous month....you can see my countif in the computation sheet but it errors out. Basically each leader i want a chart that shows…
-
Pull a value from sheet with either multiple IFs or IF combined with V look up
Hi - based on 2 different criteria I am looking to pull a date from a separate sheet. I have these attempts but had no luck - Any help suggestions much appreciated. Ryan
-
COUNT DISTINCT Using Dates
I'm trying to count how many days in a set of data based on criteria of other columns, yet it's returning an answer for the entire sheet instead of the selected IF range. I've tried =COUNT(DISTINCT(Date:Date), IF([Year / Month]:[Year / Month] = [Date Field for Klipfolio]@row)) My aim is count unique dates from "Date"…
-
Date Calculation Formula
Hi I'm after some ideas on the best way to calculate a [Date of Next Review] based on either a [Start Date] or [Last Review Date]. If the Start Date is in the last 12 months of today and [No. of File Reviews] = 0, I need the [Date of Next Review] to be [Start Date] + 3 months If the Start Date is in the last 12 months of…
-
Counting tasks across multiple sheets
Hi there. I have 17 separate project sheets. I have a portfolio-level dashboard and I want to include a metric that sums the total number of tasks across all of the sheets. I've been searching all over for the best way to do this. Some people have said countifs others have done roll up sheets and cell linking, etc. I do…
-
combining 2 criterions
Hello I need help with combining 2 criterions in one formula, =SUMIF([Project Status]:[Project Status], "Complete", LM:LM) I need to know the total LM (lane miles) for projects that are completed and located within a specific district CD Total # projects Total LM completed within District A 8 B 7 C 9
-
Removing AM/PM
Is there a quick easy way to remove AM/PM from column entries. Making 9:00 AM, 9:00 Thanks,
-
How do I update multiple cells when one cell is updated?
How do I update multiple cells when one cell is updated? Example A: If Done is checked, then Status is updated to Completed and Progress is updated to Full. Example B: If Status is updated to Completed, then Done is checked and Progress is updated to Full.
-
Help creating a formula
Can someone help me fix the following formula? # of Travel Trips = IF(([Onsite Delivery]@row = "Onsite" , [Software Installation Hours]@row >40, 1, or <41-79, 2, or <80, 3) * [Number of Sites]@row)) Not sure what to do with the ORs...or how to include them all into the formula. Do I have too many parenthesis?
-
Sum of Max Value across multiple rows
Hello, I need some help working out a formula that will let me sum the max value across 2 conditions... I have a data sheet that is getting rows copied to is when values are changed on multiple project sheets and i need to have a formula on my report sheet that returns the sum of the highest value in a day for each…