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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!