Automating Due dates
I have a sheet that has an "activity" column. Each parent line has ~15 child line subtasks that make up the "Activity" column. I need to Automate due dates for each activity. Work flows don't seem to work because they will only record that days date. I'm not sure if using a formula will work since I need different due dates for different rows.
If E&D date (separate column) is 9/1/22, I need assigned for tech review to be E&D - 3 weeks, tech review is E&D - 19 days, etc.
Each parent line has its own E&D date and the activities all have individual due dates. How would i create a formula or automation for this?
Help Article Resources
Check out the Formula Handbook template!