I'm working with a Kanban view where we drag action items into Today/Tomorrow (single select) options.
I'm currently assigning dates manually, but I'd like to automate this - so that when someone drags an item into the "today" pile, it automatically gets today's date.
I don't think it should be a formula (because that would automatically change dates on items that have been done in the past), but I can't find a way to automatically assign a date dynamically (today's date) with an automation.
Use a last modified time for the single-select in combination with the single-select value. If the single-select value is “today”, use the last modified time of the single select. If the single-select value is “tomorrow” add a day to the last modified time.
You might need some more adjusting based on what you do tomorrow and how you mark things done. You also might need to truncate the time. But this is a starting point.