Max Collect formula

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

Find more posts tagged with

Accepted answers

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.