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?

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))

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))