Add smart chips in Google Sheets
Use the table header menu to change the "Due date" column type to Date. Leave the cells blank and do not change the Milestone values.
Verified by JosephineAbout 60 secondsUse the table header menu to change the "Due date" column type to Date. Leave the cells blank and do not change the Milestone values.
Step-by-step
Select the targetUse the table header menu to change the "Due date" column type to Date.
Apply the changeLeave the cells blank and.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The Due date table column is configured as a Date chip column.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Undo the last change, reselect the intended range, and try again. The Due date table column is configured as a Date chip column.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Milestone | Due date |
| Draft ready | |
| Review complete | |
| Publish |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Use the table header menu to change the "Due date" column type to Date.
- Apply the change. Leave the cells blank and.
- The Due date table column is configured as a Date chip column.