Skip to content
  • Try Smartsheet

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

    Convert to Colum Formula on new duration column

    ✭✭✭
    in Formulas and Functions

    Hi!

    Playing around with the new duration column on calculating days between two dates. I am unable to convert to column formula. I can see that you need absolute reference which I believe I had. Hoping someone could point me in the right direction, please and thank you.

    If I use this formula I get the right answer =([End Date]@row - [Start Date])+1 but then can't convert.

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Answers

    • ✭✭✭✭✭

      Hi K.J,

      Please use @row after Start Date as follows:

      =([End Date]@row - [Start Date]@row) + 1

      Hope it will work.

      Thank You !

      Thanks,

      Anjanesh Vaidya

      Smartsheet Development, Ignatiuz Software

      Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

      · Share on FacebookShare on Twitter
    • ✭✭✭

      Thanks, @Anjanesh Vaidya. I had typed incorrectly above my apologies. That is the formula I already have working however the convert to formula option is greyed out.

      date formula.png
      convert to formula.png


      · Share on FacebookShare on Twitter
    • Community Champion

      I am guessing you enabled dependencies to get the Duration column and then disabled them in order to edit the column? I am able to replicate the same behavior so I suppose that is as intended. It is curious that the column retains the "special" formatting when disabling dependencies.

      · Share on FacebookShare on Twitter
    • ✭✭✭
      Carson Penticuff

      Thanks, Carson, you are right, and these are old columns from testing dependencies. Perhaps I'll test with a fresh sheet.

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭

      It doesn't appear that the duration column supports column formulas. @K.J It doesn't work no matter what I name the column or how basic the formula I put in is, the option to convert to a column formula is unavailable.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions