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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives