Apologies as I’m not entirely sure how to articulate what I’m trying to do.
I’d like to use this as a Vacation Rental CRM. I’d like the Base to automatically classify a reservation as “future,” “current,” or “past.” I’d like it to look like it does when I have this field set up as Single Section Option, but I’m not finding a way to combine a formula (If/Then) and that method of displaying /managing data.
I want the logic and automation of my Status Dynamic field (using formula), but the functionality/appearance of the Status Manual field (set up as a Single Select option). Something you might do with Conditional Formatting in Excel…