Pulling the Most Recent Date from a Subset of Table Columns

1

Still new to coda, and my feeling is this should be fairly simple, but I can’t seem to get it right.

We have a source table with all of our client data. We then have ~15 columns of trainings we offer clients, with a filtered view where the rows are clients and the columns are dates that the client completed the training.

What I need to do is set up a column that automatically populates with the last training date, meaning the most recent date in the filter view. (Note that we have date columns on our source that are unrelated to trainings.) Our goal is to be able to readily see whether someone has received a training in the past 3 months. If it’s greater than three months, we need to follow up with the client.

One workaround I came up with was to use Modified (), as it would be a close enough proxy to training completion date, but of course Modified() applies to the whole row, which won’t work for this purpose.

All suggestions welcome! I’ve learned a lot just by lurking here.

2

@Mckenna_Coffey

If I correctly understand your task, here’s one possible approach (filtering not included because it sounds like you already understand that part). Look at the formula in the course most recent column:

1 Like
3

Thank you! This worked perfectly, and is very simple, too. Very much appreciated.

1 Like