'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
What Do Gray, White, and Red Tasks Mean in Microsoft Planner Schedule View?
Question details
The user wants to understand the logic behind gray, white, and red tasks in the Microsoft Planner Schedule view, and whether it is possible to display monthly metrics instead of overall task metrics.
- Product
- Microsoft Planner
- Device & OS
- not provided
- Scenario
- Reviewing task schedules and overdue items on the Microsoft Planner calendar.
- Observed behavior
- Tasks appear in different colors (gray, red, white) depending on due dates and statuses, and the native dashboard only shows overall task metrics without a monthly breakdown option.
Ensure you are viewing your Microsoft Planner board in the Schedule view and that your tasks have accurate start and end dates assigned to them.
Understand Planner Schedule View Color Coding
Use this guide to interpret the default system colors applied to tasks in the Schedule view based on their status and deadlines.
Microsoft Planner automatically applies color coding to tasks in the Schedule view to help you quickly identify what is upcoming, what is overdue, and what needs immediate attention. These colors are system-generated and cannot be manually changed in this specific view.
Check your schedule for gray items. A task will generally appear gray if its due date is today or later, and its status is marked as 'Not started'.
Look for red items to find overdue work. Tasks that have an end date before today and hold a status of 'Not started' or 'In progress' will appear red.
There is no default white status color. If overdue tasks appear white, it is likely a browser rendering issue or interface glitch. Try creating a new test task or accessing Planner from a different web browser to see if the red color properly applies.
Handling Task Metrics and Reporting
Addresses the limitation of monthly metrics in Planner and provides an alternative way to view your data.
Manage Your Projects Efficiently with WPS Office
While Microsoft Planner offers basic task tracking, managing detailed project metrics often requires a robust spreadsheet tool. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, allowing you to seamlessly open exported Planner data and create custom monthly project dashboards.
- 1. Download and Install WPS Office: Visit the official WPS Office website to download the free suite and install it on your device.
- 2. Open Exported Planner Data: Use WPS Spreadsheet to open the .xlsx file you exported from Microsoft Planner.
- 3. Create Monthly Dashboards: Utilize built-in pivot tables and charting tools in WPS Spreadsheet to filter your task data by month and generate custom metrics.
Frequently Asked Questions
Why are my overdue tasks appearing white instead of red in Planner?
White overdue tasks are typically caused by a browser rendering issue or an interface glitch. To resolve this, try clearing your browser cache, using a different web browser, or creating a new test task to see if the red color properly updates.
Can I manually change the gray or red task colors in Microsoft Planner?
No, the gray and red colors in the Schedule view are system defaults based strictly on the task's status and due date. However, you can apply colored labels to tasks on the Board view for manual categorization.
How can I view monthly task metrics if Planner doesn't support them?
Since Planner only displays overall metrics natively, you can click the 'Export to Excel' option from the board's menu dropdown to download the raw data. You can then use a spreadsheet program to build custom monthly reports.
