Maxif Next Date to Review

Pestomania

Hi,

I am trying to identify the formula for doing a maxif for date.

I need to find the "next review date" for a list of documents. Here is an "excel" verison of it:

Formula in H2 is "=MAXIFS($C$2:$C$12,$A$2:$A$12,$G2)"

How cna I do this in Smartsheet?

Find more posts tagged with

Accepted answers

Leibel S

@Pestomania

You would use a MAX(COLLECT()) Combo. So something like this:

=MAX(COLLECT([Date]:[Date],[Document Name]:[Document Name],@cell=[Document Name]@row))

All comments

Leibel S

@Pestomania

You would use a MAX(COLLECT()) Combo. So something like this:

=MAX(COLLECT([Date]:[Date],[Document Name]:[Document Name],@cell=[Document Name]@row))

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, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.