Return a Minimum Date with A Condition


Hi there

I am trying to adjust summary formulas so that they only return information from rows considered In Scope (so that data does not have to be removed from Not In Scope rows).

Can anyone help with a formula that would return the MIN date from this group, only for the rows In Scope, ie Out of Scope is checked / true.

Thanks in advance




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!