Lead and Lag start time columns
Any clever hacks to have smartsheet show the leading and lagging start dates according to multiple predecessor relationships?
Answers
-
Hi @RKLRpp,
Lag and Lead times should be added to the Predecessor column along with the multiple Predecessor relationships. Use the pencil (edit) icon that appears when clicking into a Predecessor cell. You can also type the Predecessors manually, but you might want to use the editor at first to help yourself best learn the format required.
Just a reminder: negative Lag is used to show Lead time.
This results in your Start and End Date columns to be updated accordingly (along with the Duration column, or course.)
BRgds,
-Ray
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!