Cannot use negative lag time in dependency

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.

    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?



    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

  • Dannydwn

    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!