-
COUNTIFS for Escalation Tracking
I am looking to create a formula that counts the how many times over the last 12 months escalations of a certain deal size occurred. Deal size is represented as range of AUM in text format. The current formula I'm using is =COUNTIFS({Escalations Range 1}, "75M - 150M", {Escalations Range 2}, >TODAY(-365)) I created a…
-
Assistance with returning cell data base on most recent day in specified year.
I am trying to create a formula on a sheet summary that returns the information in my row titled Total that corresponds with the most recent date within a specified year. I came up with the following formula but it is returning #No Match =INDEX([Total]:[Total], MATCH(MAX(COLLECT([Report Date]:[Report Date], [Report…
-
Need a column formula to pull balance from last row
I have looked at multiple questions and threads on the community and not found an answer that works. I am trying to create a column formula that pulls the [Balance] from the previous row into the current row entry. I was getting a #circular reference error, I tried IFERROR and some recommendations on other posts, but…
-
Average Time for Chart
Hi all, I'm having trouble calculating an average duration of a time to resolve per quarter. This information is in two columns on a sheet: Time to Resolution (data type Duration) and Incident Year/Quarter (dropdown list). I've looked in the time articles and downloaded the formula template, and still missing the right…
-
How to share contacts in a published sheet?
I have contacts in my published sheet. I have it as Read Only - Full so the names can show and the emails if one hovers over it. But it doesn't allow external people to quickly copy the emails. Other than creating more columns to display the email, what other ways could I easily show the email address for others to copy,
-
Index Match for Contact List
I'm using an IFERROR formula with INDEX MATCH to pull names from two separate sheets, both of which use a contact list column type. However, for some entries, I get a contact list icon (with the email attached), while for others, I only see the individual’s name as plain text. I can't figure out why there's an…
-
MAX COLLECT Formula Question
Hi, I'm trying to create a formula that displays monthly electric meter readings. I have 2 sheets, one which I have the weekly meter readings (Meter Readings Submission) and the other is the metrics sheet which should display the monthly reading(Pitchside Meter Readings Metrics). My current formula is the below, but it…
-
Formula help with counting columns IF it has value
My bad formula that doesn't work =countifs({link to a column in another sheet} = "monitoring", AND {link to a column in another sheet} = "in review") AND ({link to a column in another sheet}, "minor") I essentially want it to count the number of "minor" risks are in "monitoring" OR "in review" from another spreadsheet. I…
-
I need to identify duplicate entries across columns on one row
Hi, I have a Crew list sheet for Sports TV Production. I have the positions listed in one column, and a column for the Crew Names for Game 1, Game 2, Game 3 and game 4. I need to identify duplicate entries across the columns for Games 1 - 4. I think I'd need a "helper" column for each of my "game" columns. I've been trying…
-
Help with ISBLANK on column formula
I am stuck getting this to work and have been trying both ISERROR and ISBLANK but keep getting an UNPARSEABLE error. Here is the overview of what I need to do: First, I have a column [Cumulative Delay for Start Date] that increments based on other values for a row. The second column is the base starting date [CALC DATE]…
