Can "=Today()" function be used as an end-date column?


I am tracking several capital projects. We have several projects awaiting approvals. We have our entire timeline setup however we do not know when approval will happen and sometimes this take several weeks. What we want to show is what the overall timeline will look like if approval happens today. What we need is to have a rolling finish-date equal to TODAY. Is this possible?

After approval, we will change the date to approval date (no longer a rolling date).


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Sheldon Kasha

    Hope you are fine, yes you can use "=Today()" function be used as an end-date column.

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Sheldon Kasha

    Morning Bassam. Smartsheets does not recognize the =TODAY() as a function. When I hit enter, it stays as text in the finish date column. Am I missing something simple? Thanks for reply.

  • Genevieve P.

    Hi @Sheldon Kasha

    There are specific columns where formula use is restricted. Although you can use the =TODAY() function in a regular date column, if this column is specified as either the Start or End date in your Project Settings with dependencies enabled you won't be able to add a formula into those cells.

    Our Help Center has a list of the fields where formula use is restricted, see: Create and Edit Formulas in Smartsheet

    I hope this help!



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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!