![]() ![]() I’m looking to create a template as I will have 4 similar events each year, so it’d be helpful to be able to put the event date and those tasks will automatically fill in their start date. Is there a formula that I can use in the formula column that will put a correct date in the formula field based on whether the task is a months, weeks or days task? The formula field supports 98 different functions and operatorsand there are almost boundless possibilities for how you can use them. 4) and for the weeks or days tasks I have it listed with # Weeks (IE 2 Weeks, 2 Days). Formula fields use both operators (think your basic mathematical symbols like + or ) and functions (more advanced calculations, such as parsing dates and times, figuring out averages, and rounding). In the column - right now- I have a whole number if it’s for months (ie. ![]() For an overview of formula fields, please. Project Start (Months/Weeks/Days Out) is the column that has the # of Months/Weeks/Days out we need to start working on the task. Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. I’m using this formula in the column (the DATE and Project Start are the columns I’m having it pull data from): DATEADD(Date,-,‘months’)ĭate is pulling from the Date column that i have the first day of the event in. those that needed to be start 2 weeks out, etc. I had to go in each cell to change the formula for the specific task for those that were 1+ months out vs. In my google form/excel sheet I have formulas created so that all I have to do is put in the first day of the actual event into a column, and then another column has the # of months, days or weeks out that we need to start working on that particular task for the event. I’m putting together a checklist for a large event that has due dates- start and end dates included in the table. If your table is going to used and read by people, you'll probably want to alter your date to be a little more human friendly. I’m a complete newb to airtable, so I’m still learning the intricacies to see if it’s something I can use in my role. If you add a date field to a formula without using the DATETIMEFORMAT function, the formula will display both the date and time in a simplified ISO formatting. I know Airtable is not a “spreadsheet” and that typically you cannot use different formulas per row/cell because of the database situation. See below for a quick example of how DATETIME_FORMAT can transform a date field from one format to another.I’m trying to see if there’s a way I can do this. For a full list of supported format specifiers, please see this article. The format specifier can be something like 'DD-MM-YYYY,' 'YYYY/MM/DD,' 'MM.DD,' etc. The format specifier will allow you to dictate the structure of how your date should be returned. The formula will follow the recipe of: DATETIME_FORMAT(, '') The DATETIME_FORMAT function will allow you to reformat the data from a date-type field into a string following your specifications. For more information on DATETIME_FORMAT, and other formulas, we recommend checking out the formula field support article. Airtable has many built-in functions to get the dates and times of different events as well as to compute durations, add durations to dates, compare dates and times, and more. If you would like to incorporate a date (and time) type field into a formula field, the best way to format that date is using the DATETIME_FORMAT function. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |