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

Sheldon Kasha

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

Hi @Sheldon Kasha

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

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!

Cheers,

Genevieve