Max Collect latest date based on 2 criteria

Hello,

I am trying to get the latest date to populate by using MAX and COLLECT based off of the Zone being Ambient, and the Floors checkbox being checked.

This is what I currently have: =MAX(COLLECT({When}, {Where}, Zone@row, {Floors}, =1))

Here is where I am pulling the data from:

And here is where I am hoping to have the date populate:

Thank you!

Find more posts tagged with

Accepted answers

All comments

Make sure both columns are set as date type columns.

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.