Maxif Next Date to Review

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?



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!