MAX COLLECT for dates in a row
I have a certification that requires a few lessons to be fully certified. Each lesson has a completion date in it's own column and a date column for when they become fully certified. So, if there if one training is missing a completion date they are not considered fully certified.
My need is to be able to collect the max date of the all training completions for that certification per the employee. This would be collecting the max date for rows, not columns. Is this possible?
Thank you - Ron
Best Answer
-
You can skip the collect and just use MAX():
=IF([Fully Certified]@row = "Yes", MAX([Train Date - Blower]@row, [Train Date - Broom]@row, [Train Date - Chem]@row), "")
Answers
-
Can you post a screenshot? What you are asking can be done, but the approach kind of depends on how you have things setup.
-
I will add a column to capture the date the employee became fully certified. Here is a screenshot:
-
You can skip the collect and just use MAX():
=IF([Fully Certified]@row = "Yes", MAX([Train Date - Blower]@row, [Train Date - Broom]@row, [Train Date - Chem]@row), "")
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