Unable to use formula based date column in gantt/timeline
Any workarounds welcome. I'm importing some task data using Data Shuttle. The task data includes Created Date, Start Date, End Date. We want to use a column formula to set the start date (if its empty) to equal the Created Date. Easy enough.. I renamed the incoming Start Date column and added a new Start Date date column, and added a column formula to populate the Start Date with our logic.
Then when I go into Project Settings to set the Start Date, the formula based date column isn't selectable.
Best Answer
-
Thanks @Paul Newcome.. I found another possible workaround..and actually I'm thinking this is the best solution. In the Data Shuttle job I added my formula to an Input Expression. I mapped the Start Date column to this value, and it seems to be working as desired!
Answers
-
I tried a workaround.. I added a 'helper' column to hold the formula below. The formula sets the Start Date valueβ¦this worked until the next Data Shuttle ran. The helper column still exists but the formula isn't automatically setting the [Start Date] with the formula in the helper column.
=IF([Imported Start date]@row = "", [Start Date]@row = [Created Date]@row, [Start Date]@row = [Imported Start date]@row)
-
Found another possible workaround. My question though is, will a non column formula apply to new rows?
-
You can use a formula to drive the dates in the Gantt, but it can't be a column formula.
Non-Column formulas will apply to new rows so long as there are at least two rows containing the formula immediately above and/or below the new row.
-
Thanks @Paul Newcome.. I found another possible workaround..and actually I'm thinking this is the best solution. In the Data Shuttle job I added my formula to an Input Expression. I mapped the Start Date column to this value, and it seems to be working as desired!
-
I missed that you were using Data Shuttle. Glad you were able to get it sorted.
Help Article Resources
Categories
Check out the Formula Handbook template!
