HELP!!! Max Collect for Dates
I utilize Smarthsheet to manage a hospital schedule. I need to find out the last time a staff member worked.
I have been playing around with Max Collect and constantly failing… #UNPARSEABLE
Things to note: The Primary column shows the name of the staffer multiple times with multiple different dates under the Date Worked column. I am looking for the formula to tell me the most recent time the staffer worked.
Here are my columns:
1st column - Primary Column = Names of the staffer (Text/Number formatting)
2nd column - Date worked = Dates that the staff member worked (Date Formatting)
3rd column - Last date worked = Where I am looking for the formula to output the last date (Date Formatting)
I have tried this… but honestly i am soooo so lost here.
=MAX(COLLECT([Date worked]:[Date worked, [Date worked]:[Date worked], ISDATE(@cell ), Primary Column:Primary Column, Primary Column@row))
I have created an example of the schedule below:
Best Answer
-
=MAX(COLLECT([Date Worked]:[Date Worked], [Primary Column]:[Primary Column], [Primary Column]@row))
Larry Cummings
https://primeconsulting.com/
Principal Consultant | Prime Consulting Group
Answers
-
=MAX(COLLECT([Date Worked]:[Date Worked], [Primary Column]:[Primary Column], [Primary Column]@row))
Larry Cummings
https://primeconsulting.com/
Principal Consultant | Prime Consulting Group -
omg THANK YOU!!!
You're a life saver!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 390 Global Discussions
- 212 Industry Talk
- 446 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!