I'm trying to edit someone else's gnatt chart in Gsheets to change the colours of the timelines based on the status.
The sheet I'm editing changes the colour based on the status of a check box. However, I need a formula that will pull in the status based on a drop down: 'in progress', 'delayed' and 'complete', then I can use conditional formatting to colour the cells for each status.
image.png
In this example, the original format is top row, want I want is below, with the drop down menus
That is the current formula.
What formula do I need, so it will pull in the text of the status?
Bookmarks