How to make my due date column continuous and with a specific time range in between dates

I am trying to make the due date column so that it enters a date for every 22 days. I want this to be an "endless" column in that it goes all the way down without having to be manually entered. Is there a way to set the due date column to calculate this automatically and fill out all of the rows under it?


Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hey @Alicia D

    No formula needed! 😊

    Add two dates in with your preferred day-difference:

    Then click on the blue square in the bottom-right corner and drag-fill those dates down your column. The sheet will automatically pick up on your pattern and increase the dates by the same number of days between your first and second date:

    Here's more information: Create a series of numbers or dates with drag-fill

    Let me know if that makes sense and works for you!

    Cheers,

    Genevieve

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!