Developing a Portfolio Roadmap - Apostrophe being added to formula


I'm trying to develop a Portfolio Roadmap (Gantt View) that is driven by both the Start / Finish dates of Live project schedules and planned Start / Finish dates of future projects.

Start / Finish columns = Linked to Live project schedule for approved projects

Portfolio Plan Start / Finish columns = Manually entered for proposals (future program / portfolio planning)

Roadmap Start / Finish = Formula driven to use appropriate date above based on [Project Status] and also drives the Gantt Chart

The problem is that whenever I enter a formula in the Roadmap Start column, an apostrophe is being added to the beginning of the formula. All columns are date only.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!