Lead and Lag start time columns

Options

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

Answers

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

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!