![]() This is especially useful for collaborative tables, where work has to go through several hands in a specific, timely process. In this instance, DATEADD() can help automatically map out the strategic dates for each project based on your established timeline, reducing the need for mindless number crunching on your end. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |