Automatically change single select based on date


#1

I’m building a task tracking dashboard. For a given task row I have a single select field with various status levels included “Scheduled” and “Today.” I also have a Date field called “Scheduled for” where I forecast the date I want to do that task.

When I create a task I want to schedule out I choose Scheduled for the Status field and enter a date in the Scheduled for.

I would love it if the base would automatically update the Status field to “Today” when the "Scheduled for date matched today’s date.

I suppose something like this is possible with a formula to display what I want to see, but I also want to use a Kanban view and those require a Single Select field to group by.

Ideas? Feature request?


#2

Some ideas: