In my base I have 3 fields where various dates are entered, based on when a client was contacted. Basically a first, second, and third touch point in communication.
I have a fourth field that currently pulls the most recent date based on what’s entered in the other 3 columns. If only the first contact field has a date, then the most recent outreach is that date. If the second contact point has a date, then it assumes that date is most recent. Same with the third contact date… if anything is entered into that field, it assumes it’s the most recent.
My issue is that sometimes, 6 months to a year down the road, the contact points may start over, and that first date may become the most recent date. (But because there are still dates entered into the other two fields, the 4th field assumes they are still the most recent, when they aren’t)
Is there a way for it to calculate within the system which of the three dates is actually the most recent date?
I hope that makes sense!