What is the formula to subtract today's date from due date column so I can see remaining days

Best Answers

  • Sandra Guzman
    Sandra Guzman ✭✭✭✭✭✭
    Answer βœ“

    Hi @ccortes,


    Try this formula. Make sure that the column header is documented as it is in your sheet and replace "Due Date" in the formula below as appropriate. You will want to also convert this to a column formula if you have multiple rows that you want this to apply to.

    =TODAY() - [Due Date]@row


    All the best,

    Sandra

  • Sandra Guzman
    Sandra Guzman ✭✭✭✭✭✭
    Answer βœ“

    Hi @ccortes,


    Glad the formula worked for you! Please make sure to mark the response as yes to answering your question. 😊


    As for converting to a column formula, all you need to do is right click in the cell that you added the formula to. You should see the menu of options available to you. Scroll down and click on the "Convert to Column Formula." Once you do that you should notice the formula symbol added to the column header.


    Menu of options to convert to column formula.


    Formula added to column displays fx in the column header.


    All the best,

    Sandra

Answers

  • ccortes
    ccortes ✭

    Do you guys know how the formula to subtract today's date from the Due Date column so it will display the remaining days in the Remaining Days column?

    I do not have a today's date column as I am thinking this is auto generated since it is a smartsheet. Any advice?

  • Sandra Guzman
    Sandra Guzman ✭✭✭✭✭✭
    Answer βœ“

    Hi @ccortes,


    Try this formula. Make sure that the column header is documented as it is in your sheet and replace "Due Date" in the formula below as appropriate. You will want to also convert this to a column formula if you have multiple rows that you want this to apply to.

    =TODAY() - [Due Date]@row


    All the best,

    Sandra

  • ccortes
    ccortes ✭
    edited 03/15/22

    This worked perfectly!!!! I noticed you said I should convert this to a column formula if I have multiple rows, how do I do that so each row will have this formula?


    Thank you Sandra!

  • Sandra Guzman
    Sandra Guzman ✭✭✭✭✭✭
    Answer βœ“

    Hi @ccortes,


    Glad the formula worked for you! Please make sure to mark the response as yes to answering your question. 😊


    As for converting to a column formula, all you need to do is right click in the cell that you added the formula to. You should see the menu of options available to you. Scroll down and click on the "Convert to Column Formula." Once you do that you should notice the formula symbol added to the column header.


    Menu of options to convert to column formula.


    Formula added to column displays fx in the column header.


    All the best,

    Sandra

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!