Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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.

Answers

  • 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:

    Screen Shot 2021-03-29 at 2.14.50 PM.png

    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?

    Cheers!

    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

  • 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!

Trending in Formulas and Functions