Count Down Formula

Hi All,

Does anyone have a formula that will count down to a specific date?

Thank you.


Best Answer

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓

    Hey @Stephanie Taylor !

    Try this:

    =TODAY() - [Date Counting To]@row

    This will give you a negative number that gets closer to 0 as the day gets closer.

    If you want to use positive numbers, just swap the two values.

    (replace the "[Date Counting To]@row" with your actual

    Let me know if that doesn't work for your purposes or if you need any further help!

    -Jon Mark Heaner


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!