Currently, Gantt charts are

[kexej28769@nongnue]

When our filter formula returns our specific category of work, we take that value and run a vlookup on the Status and Color Code tabs. (This is only necessary so that I can set up conditional formatting for you so that it doesn't break when you change the specific category names.)

Currently, G antt charts are set up to color-code the first 7 categories, and the deadline category if needed. If you want to add more, they will initially appear as black blocks in the Gantt switzerland number data and you will need to set up conditional formatting to color-code them.

To add automatic color formatting for more categories,پلانر میں ہر گانٹ چارٹ ویو کے لیے ذیل کے عمل کو دہرائیں۔and Stakeholderشیٹس:

Select all cells in the tab.
Select "Conditional Formatting" from the Format menu.
Find the rule with the black box next to it and note what number it is currently targeting.
Create a new rule for anything that equals the number in step 3, then set the same color for both the background and text of that rule.
Change the rule that has a black block next to it to target one number higher.
کیٹیگری فلٹر ایبل گینٹ چارٹس کو کیسے کام کریں۔
This tab uses our old friends, the =filter() and =query() functions. First, we زمرہ جات کی مکمل فہرست حاصل کرنے کے لیے اس فلٹر کا استعمال کریں جس کا ہم نے پہلے ذکر کیا ہے۔the Status and Color Code tab.

=FILTER('Gantt view'!A6:B,RegExmatch('Gantt view'!A6:A,".*[a-zA-Z].*"))
Then we attach Google Sheets' shiny new checkboxes to them (which will help us filter our data easily).