From there, the formula helps populate these fields relative to the due date.įor example, if your first draft has to systematically be submitted 7 days before the final due date, use this formula: Let’s automate that with the DATEADD() function we discussed earlier.įirst, you need to create a final due date field in your table, and a field for each of the steps in your process: first draft, first review, revision, editing, etc., whatever the case might be. The point is that if the timeline is always the same, setting up the different steps in the process (first draft, editing, confirmation, or last review, for example) every single time can get time-consuming. Marketers running campaigns for A/B testing Īnd the list goes on.Agencies working with the same clients.Automatically Populate Your Project with Due Datesĭepending on your activity, due dates might be something you have to add over and over again: Airtable features a number of functions that can serve as a base to your formula experiments, and plenty of tested formulas for you to have fun with.ħ. It may seem like a daunting task to start putting together formulas by yourself, but don’t worry, there’s no need to be a maths genius here. The possibilities are only limited by your imagination and the scope of your projects.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |