Hi, is Airtable able to do Finish to Start formulas that autofill dates similar to smartsheets? I’d love to have a sheet with the tasks and deadlines are autofilled based on the formula for how many days from Go-Live, so all I would enter is the Go-L...
Hi, I’m looking for a way to streamline entering the same data in Airtable in a few different places. I enter due dates for an entire project, but we have SMEs that enter some of the same due dates in another tab for when each individual channel will...
Hi, I’m looking to set up automations to remind me of due dates. I was using a datetimediff formula, but it says NaN. I want to take todays date-the due date and have it show how many days until the due date, then I was going to schedule an automatio...
Thanks so much, Im not sure why it wasn’t filtering out the other calendars, but when I switched the formula so overdue tasks are negative its now filtering all correctly via email. Thank you!
Kamille, this is so articulate and helpful, thanks. I was able to get the email sent to me by switching email and records and fixing the typo, however, when the email sent it’s not filtering by the 2 conditions I have 1. needs to just be the editoria...
Kamille_Parks:
DATETIME_DIFF(TODAY(), {Due Date }, 'days')
Thanks for your reply Kamille. I used your formula and it populated the number of days until it’s due. I’m still not able to get the automations to work though. Do I need to have a fie...
