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.
EX.
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?
Answers
-
you could do an equation like =([E&D Date]@row+ 21) or however long you want to set the due date for. You can also set conditional formatting and make automations to send out notifications based on this due date.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!