Timeline In Google Sheets

Steps to timeline in Google Sheets

• Step 1: Select the column you want.
• Step 2: Navigate to the Insert tab, choose Timeline, then click OK.
• Step 3: Open the Settings window, then select Task for Card Title, Key Person for Card Colour, and Card Details (e.g., designer, developer).
• Step 4: Return to Sheet1, go to the Format tab, and choose Conditional formatting.
• Step 5: Under Format rules, select Is equal to, pick a name (from Key Person), choose a color, then click OK.

Result: You’ll now have a timeline visualization where each card reflects your customized task details and key person, along with color-coded formatting based on the assigned individual.

Tip: Use distinctive colors for each key person to quickly identify responsibilities at a glance.