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
-
Hi @Saad
I'm glad to hear this was resolved! Thanks for posting your solution 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
I would like to add
{date} is referencing a column from 2nd sheet
{conditions} is also referencing a column from 2nd sheet
-
Sorry, I corrected the references and my issue was resolved
-
Hi @Saad
I'm glad to hear this was resolved! Thanks for posting your solution 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
Check out the Formula Handbook template!