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.