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.
Help Article Resources
Check out the Formula Handbook template!