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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!