Hello y’all. I’m trying to setup a table so that dates can change in a column based on data in the other column.
Here’s how it works.
In one column is the Overall Due Date for a task (let’s say it’s August 20th). In the next column, I have a dropdown menu field called “Status.” The options there are “Need to be recorded,” “Need to be Edited,” and “Need to be Uploaded.” So let’s say the current status of an item is “need to be edited.” I would like to set it up so that in a third column, a date could be generated that calculates a new date based on that specific status. So “Need to be recorded” calculates a date 10 days in advance of the overall due date, “Need to be edited” calculates a date 3 days in advance of overall due date, and “Needs to be updated” is 0 days in advance of overall due date. I’m fairly new to Airtable, so unclear if this is at all possible or if it’s too complicated. Any help is appreciated!