Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Question regarding lag times

Lainie Franklin
Lainie Franklin ✭✭✭✭
edited 12/09/19 in Archived 2015 Posts

I am using predecessors in my spreadsheet and need some assistance with lag times. 


For example, one task is to sign the contract with the meeting planners (we do that in November)--that's line 12 in my sheet. Our first payment is not due to the planners until June of the following year. If I put line 12 in as the predecessor for the first payment, Smartsheet changes the dates of the payment due. I have to play with it quite a bit to get the right lag time recorded. Any help appreciated. 


Thanks so much!




  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 12/22/15



    Predessor lead and lag times are discussed in this article:



    If I understand correctly, you want the Payment Due date to be in the future, say 6 months.


    In the Predecessor column, 


    12FS + 26w 


    will start the task when row 12 finishes ("12FS") in 26 weeks (6 months).

    Smartsheet does not have months for predessors lags/leads so use weeks (13/weeks per 3 months). 

    If you use the dialog box, it only accepts days.


    Be aware that with Dependencies enabled, you cant use formulas in the Project Setting columns so getting the Payment Due date to be the first or last of the month (for example) six months from now is harder.


    If that is what you are shooting for, there are work-arounds.


    Hope this helps.







  • Lainie Franklin
    Lainie Franklin ✭✭✭✭

    Your explanation helped greatly. Thank you so much! 


This discussion has been closed.