Hi guys,
I’m trying to come up with a formula that will calculate the number of days that has passed and based on that number, change a label in a field.
Here are the specifics:
I have an airtable for keeping track of job applications that I’ve submitted. I want to automatically update a label field based on the day that I applied.
Example:
I apply for a job and mark the date (date field), then I manually set a field called Follow up to “recently applied”. Then after 7 days, I manually change that label to “Send 1st follow up”.
So how do I create a formula that would basically do this:
if(date applied < 7 days){
set the label to “Recently Applied”
}
if( date applied is between 8 and 16 days){
set the label to “send 1st follow up”
}
if( date applied is between 17 and 24 days){
set the label to “send 2nd follow up”
}
else{
set the label to “maybe you should send your application”
};
Thanks in advance for the help!