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.