Skip to main content
What is the proposed idea/solution?

Enable date formatting on formula columns

How does is solve the user problems?

My use case for this would be to insert templates or build template tables for project management on events we do over and over again. For example, if we plan a webinar, we know which tasks need to get done in what order and how many days apart. We have a formula for how many days before or after the live webinar date each task needs to be done. If I include a column for the live date and include the variance to live date, I should be able to auto calculate the due date for each task but there isn't a format that allows for this.

You can do this with formulas 🙂 

add/subtract days

 

DATEADD([date], [#], 'units')

 

to add/subtract non-weekend/non-holiday days

 

WORKDAY(startDate, numDays, [holidays])

 

to format text based dates to work with calendar views/filters/date formulas

 

DATETIME_PARSE(date, ['input format'], ['locale'])

 

and more!

Formula reference https://support.airtable.com/docs/formula-field-reference#date_and_time_functions

You might also find record templates useful https://support.airtable.com/docs/using-record-templates-in-airtable

Reply


Terms & Conditions