MAX COLLECT for dates in a row

Ronald Anderson

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

Carson Penticuff

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), "")

Carson Penticuff

Can you post a screenshot? What you are asking can be done, but the approach kind of depends on how you have things setup.

Ronald Anderson

I will add a column to capture the date the employee became fully certified. Here is a screenshot:

Carson Penticuff

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), "")