Formula Help - Countdown

Looking for assistance on a formula that calculates the days remaining from the current date to the expiration date - any ideas?

Best Answer

  • Mark.poole
    Mark.poole Community Champion
    Answer ✓

    @Aaron Minogue

    This is a fairly simple formula.

    =[FORS Expiry Date]@row - TODAY()

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Answers

  • Mark.poole
    Mark.poole Community Champion
    Answer ✓

    @Aaron Minogue

    This is a fairly simple formula.

    =[FORS Expiry Date]@row - TODAY()

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!