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).


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!