Trending in Formulas and Functions
-
Summary Sheet Formula
How do I write this formula in on my summary sheet? I'm trying get total count of Reggie's "In Progress" tickets. Will this also count if the field has 2 names in that field? For example the field has both Reggie and Jon. =COUNTIF([Assigned To]:[Assigned To], "Reggie Andaya", [Status]:[Status], "In Progress")
-
Using AVG(COLLECT())
Good afternoon, I'm trying to do the equivalent of '"AVERAGEIFS". I read about using the collect formula, but I'm having an error. The formula I'm using is: =ABS(AVG(COLLECT({Master Sheet - 1960 - Net}, {Master Sheet - 1960 - Date}, Date@row, {Master Sheet - 1960 - Info}, [Summary Info]@row))) I'm trying to calculate the…
-
Identifying data associated with a previous row
Thanks in advance! From a listing of all meetings, I am hoping to pull in the date of the previous meeting. Note, there are no successors/predecessors with this (I've been able to successfully use Paul's post in other areas to pull in the task name and hoping somehow this could be similar?) Has anyone done anything…