Cannot use negative lag time in dependency

Dannydwn ✭
edited 03/28/21 in Formulas and Functions

When i try to use a negative number eg. -10d in the field "lag" to create a lead in dependencies I get an error "Invalid lag duration".

Am I misunderstanding the help or is it not possible?

thanks in advance.

Edit: manual input in column did work 😁, only not via the editor.


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Dannydwn

    I'm glad you were able to get it to work! You should be able to add it into the editor as well, though:

    If you're still receiving an error through the Edit Predecessors window, could you provide a screen capture (like above) with the message? What are you sharing permissions on the sheet?



  • I did try again today via de Edit Predecessors windows and it worked just fine. I’m not able to replicate the error anymore.

    This topic can be closed.

    When I’m getting this error again, I will make a new topic and add a screenshot and the permission rights.

    Thanks for the help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!