I have a habit/task table, the time period is on a multiple choice column (daily, weekly, bi-weekly monthly, etc.). I keep track of the last time it’s done (the date).
Is there a formula that can take both into consideration and tell me if something is overdue?
for example if it has been more then a week since i did a weekly task.
“Frequency” is the field where you will select the time period of the task. Each case adds the correct time period. Then you can create a second field that compares the “due date” against the current day:
Airtable is weird about quotation marks. Sometimes if you copy and paste from a different program, you end up with the directional quotations like in the above text, which it doesn’t like. Try redoing those - otherwise, your code looks great! In terms of empty cells, you could do something like this:
The first IF() checks to see if there’s anything in “Last completed”, and if yes, it goes to the second IF(). You could also make a case in the Switch() statement to cover this so that it doesn’t show #ERROR when the cell is empty.
I didn’t do it in a different program i did it on airtable, that’s what’s weird.
It’s my first time trying, never tried to code before and was just trying to make it like the previous one you sent.
Don’t know how to code so i didn’t understand the last part about using a switch to make it ignore empty cells, currently I’m using only the yes rather then yes and no to make it pop out.