Question

I have the following working formula that I need to modify to look for either two people in the "Resi - Onboarding Specialist" column in addition to meeting the date range. The formula below is working for one application but the next application needs to also include calculating the median if the "Resi - Onboarding Specialist" column contains either Bob Smith or Susan Jones

=MEDIAN(COLLECT({Resi - Pricing & Tools Duration}, {Resi - Enter Stage 7 Date}, AND(@cell >= $[Start Date]$1, @cell <= $[End Date]$1), {Resi - Onboarding Specialist}, @cell = "Bob Smith"))

I was thinking that there needs to be an OR statement but I just don't know where to add it. Several attempts only give me an #INVALID DATA TYPE error.

Nic Larsen · Accepted Answer

If the rest of the formula works, then to add the Or should just be this:

{Resi - Onboarding Specialist}, OR(@cell = "Bob Smith", @cell = "Susan Jones")

Nic Larsen · Accepted Answer

That shouldn't matter that they aren't found in the column. I would double check your formula. The end would follow the same pattern as above.

{Resi - Onboarding Specialist}, OR(@cell = "Bob Smith", @cell = "Susan Jones", @cell = "Cathy Morgan")

GMichal · Accepted Answer

Thank you once again. It took me a while but I left off the quotes after "Morgan". I appreciate you keeping me sane on this one.