Column Formula not selectable as Gantt Label
Is this a bug?
For Gantt chart labels, I use a column that concatenates and formats the task and end dates; call this column "Gantt Label". I select this as my Gantt label and it looks great.
To prevent my formula from getting corrupted or broken, I convert "Gantt Label" to a Column Formula. Here's where it gets interesting...
- If I already have "Gantt Label" selected, the Gantt chart looks great
- If my chart starts with no labels, and I try to select "Gantt Label" as the label, it's not available from the dropdown menu!
- If I convert the column formula back to a cell formula, "Gantt Label" reappears as a label option
Curiouser still...on a sheet where the labels are showing correctly and I'm using column formulas, if I go back and check which column is being used as the label, the selection is "None" even though the labels are showing.
Again, the Gantt labels don't seem to find Column Formula columns, but will work if you convert to Column Formula after selecting it as the label.
I can work around it, but is this a bug?
Help Article Resources
Check out the Formula Handbook template!