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.

    Simple sell date - buy date formula

    ✭✭
    in Formulas and Functions

    Hey all. Trying to do a column equation that shows how long an item has been sitting on a shelf.

    Lets call the two columns Sell Date and Buy Date. I'd like to see the amount of days between Sell Date and Buy Date. If I bought inventory on 1/1 and sold it on 1/10, I'd like it to read "9' for "Days on Shelf" column.

    What's the best way to do this?

    Tags:
    · Share on FacebookShare on Twitter

    Answers

    • Community Champion

      @Mycelus You could use SmartSheet native functionality and use the column called Duration. You could even show the length of "Days on Shelf" on a Gantt chart.

      Otherwise, I use a formula along the lines of ([Sell Date] - [Buy Date]) regularly. The function NETDAYS is a bit more sophisticated.

      (I recommend activating a Gantt chart and let the SmartSheet functionality manage it. Just beware of vacation and weekend days.) =days

      Cheers,

      dm

      · Share on FacebookShare on Twitter
    • ✭✭
      edited 12/15/21

      I was able to do =([Sold Date]@row - [Bought Date]@row) and that did the trick, thank you!

      · 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