We are using Airtable to manage video editing tasks. We have a workspace for every video editor, and in every workspace there are multiple projects for the clients the editor has. In every project there is a column with Due Date for the video. Is it possible to create a project, that would show all submissions based on the Due Date? In this table I would like to see Tasks that are near the Due Date and tasks that are late. When video is confirmed and final files are uploaded, we remove the Due Date, so I would only see the videos that are still in progress.
All help will be appreciated,