i’m trying to manage my team using Airtable as a CRM.
In my database, i have a table for the different person of the team, and one for the tasks, with a field for the priority of each one : ongoing, urgent, finished.
I want to send an email everyday (using zapier) to each person of the team with the “Urgent” task to do.
For that, i need to create a formula that will display only the “urgent” tasks.
Do someone knows about this formula ?
Thanks for your help