-
My column formula =COUNT(DESCENDANTS()) returns #BLOCKED in one cell. Is there a limit to the count?
All other column formulas work fine. The only reason I can think of is there may be too many descendants? The value returned should be 1540. Is there a limit to the COUNT function?
-
Cross-Sheet SUM formula roadblock -- any formula wizards who can help?
Hello! I'm currently using a cross-sheet formula to pull in multiple cells of numeric information in a column on 1 sheet and return as 1 cell in another. I'm doing this using a JOIN(COLLECT formula. =JOIN(COLLECT({Dev Spend Auspice Tracker - Development Fees}, {Dev Spend Auspice Tracker - ID}, ID@row), SUBSTITUTE(HELPER#,…
-
Possible to return original entered value in formulas?
Hi there! I'd like to use a simple IF expression to test a condition in another column. If that statement returns FALSE, I'd like to KEEP the originally entered data in the cell. Is something like this possible? The Unfilled column is a check box to indicate that a staffing shift is currently unfilled. If the box is NOT…
-
Calculating Difference Between Multiple Dates
Hello, Curious if there's a single formula to calculate difference between Planned and Actual for both start date and end date? Trying to get the Total Time +/- value. Thanks.
-
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