Is there a way to automate a single select field based on a formula? I am attempting to create a Kanban view which displays critical dates for my drivers.
I own and operate a logistics road freight company in the Middle East. I currently maintain a google sheet of my drivers’ expiration dates for their passport, driver’s licenses, visas, waqalas, etc.
I then use this as a watch list for critical dates via highlight any date that is within a 90 day window of expiring.
I was looking to create the same type of “watch list” via using a Kanban view.
I have created all the necessary DATETIME_DIFF formulas based on today’s date.
But not sure how I translate a formula that displays a date that is < 90 days into a single selector Yes/No field.