Max Collect formula

Sue van Niekerk

HI All ,

I have a sheet that I am using a MAX(COLLECT formula,

I need to add to the formula

=MAX(COLLECT({date}, {team}, Name@row)) I need to add another column before the name row that will give the name of the person reporting the audit

So I am collection the last date of a field audit for Team member done by Auditor

Genevieve P.

Hi @Sue van Niekerk

You can add more "filters" to a COLLECT Function by first listing the column with the content you're filtering by and then the criteria.

For example:

=MAX(COLLECT({date}, {team}, Name@row, {Auditor}, [Auditor Name]@row))

Let me know if this is what you were looking to do!

Cheers,

Genevieve

Genevieve P.

Hi @Sue van Niekerk

You can add more "filters" to a COLLECT Function by first listing the column with the content you're filtering by and then the criteria.

For example:

=MAX(COLLECT({date}, {team}, Name@row, {Auditor}, [Auditor Name]@row))

Let me know if this is what you were looking to do!

Cheers,

Genevieve

Sue van Niekerk

Hi Genevieve

I have tried it out - cant seem to get it to work

Genevieve P.

Hi @Sue van Niekerk

Invalid Ref means that one of your cross sheet references is incorrect.

It looks like you may have inserted the criteria into the {Reference Name}. See how the ending of your formula has 3 brackets, and one of them is curly? }

Make sure that your {reference} ends before the comma, then the [Travis Audit]@row cell name.

Cheers,

Genevieve

Sue van Niekerk

Brilliant - thank you so much got it working :-)

Genevieve P.

Wonderful! I'm glad I could help.