Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 24, 2023 03:03 AM
I want to create an Project Management Table with the following requirements
so whenever something changes, the following dates should change as well. (also reflecting the dedicated duration set for each task)
I tried with formulas or dependencies but could not figure out a way to automate this, instead of updating all records manually if one date changes.
Thanks
Helenelene
Aug 05, 2023 10:44 AM
I have this working partly with make.com and airtable together. What you need to do is connect each task and lookup the finished date. Then when that is filled in add one day to it to schedule the start date of the next task. You should be able to do this with Airtable's automations to copy over the new date to the field after adding a business day.
Feb 19, 2024 01:47 AM - edited Feb 21, 2024 01:51 AM
Exciting project ahead! To set up your Project Management Table with dynamic dates, you can use Excel or similar tools. Try using formulas like "=IFERROR(MAX(End_date_previous_task + 1, Previous_stage_end_date + duration), "")" for start dates and "=Start_date + duration" for end dates. This way, changes in one task automatically adjust the following stages. As for ERP, it streamlines processes by integrating various functions across your organization, promoting efficiency and data consistency. How does ERP work for your projects?