Automatically change single select based on date

[Corby_Stephens]

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?

[Elias_Gomez_Sai]

Some ideas:

• Just create a View to see only tasks with Date of Today
• Create other field called Today, of type Formula, and output some alert text: https://support.airtable.com/hc/en-us/articles/221104988-Conditional-formulas-with-emoji
• User Zapier to change the Status to Today. But I think the previous ideas are easier.

[Brenda_Carey]

Hi, I know this is an older question, but how would I use Zapier to change the Status?

[Elias_Gomez_Sai]

Use the Update Record action.