I am trying to get latest date from a column

I have a column name Conditions having values A,B,C. There is also a column with created date in it.

I am using this formulae

=MAX(COLLECT({date}, {conditions}, "B"))

It gives 0 when column type is text\number

empty if column type is date

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!