I have a table that manages all projects in estimating
each record has a “Received Date” field and a “Due Date” field
these are manual field that each estimator has to fill out when when they receive a new project to bid on, and i have built some automation based on the due date.
New here my problems, since this is a manual field, sometimes estimator might forget to fill in the due date field, and then any associated triggers won’t work, so i want to create an automation that if the Due date field is left blank, it should automatically be filled in with a due date of one week from when the record was created.
i have tried to play around with the automation, but i couldn’t figure this one out how to generate a date of onw week from when the record was created…
This is my Table
Here is Part 1 of the Automation
Here is Part 2 (that’s where i’m stuck…)