Hello,
I am trying to use Gantt view to display project timelines. I recently figured out that a Formula Column cannot be used to display Gantt timelines. We used the Copy Row automation to make a second sheet with all the data, but none of the formulas. We formatted the columns as Date, and switched on "Date Only." However, Smartsheet won't recognize the date for Gantt use UNTIL I click in the cell, and hit enter. I don't change anything in the cell, but as soon as I do that the date populates on the Gantt chart. Is there a way to fix this, or get around this? It seems vaguely familiar to an excel issue where you would have to run Data Validation on copied data to make excel recognize it for what it is.
I want to avoid adding MORE formulas to the original sheet that aren't Formula Columns because rows are constantly added to it. I am using a basic Index/match to pull the date value from another rollup sheet. Any insight would be appreciated.
Example: First I clicked inside the cell and hit enter, Second I did not yet.
