Lead and Lag start time columns


Any clever hacks to have smartsheet show the leading and lagging start dates according to multiple predecessor relationships?


  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 01/23/23

    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.)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!