Share via

Planner Export to Excel has wrong data

Anonymous
2020-06-05T13:30:04+00:00

Hi all:

I exported Planner's tasks to an Excel file and I found that the Late column shows false when the Completed date is later than the Due Date.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2020-06-06T08:28:30+00:00

    Hi walterdp,

    The data should be consist with planner. You can go to Planner, click Charts tab > Late to compare them. It's not related to Planner export feature or Excel I think.

    I made a quick test and would like to share my finding. Seems for Incomplete tasks the column compares Due Date with export date/current date and shows no problem. But it converts to false when a task is Complete.

    Seems the Late status only count the incomplete tasks that has a redmark which warns date expired in planner mainpage, for completed tasks the redmark disappeared automatically so the Late value will be changed from True to False.

    It's a good idea to share this information in Planner UserVoice and the relevant team will keep improve our product. We appreciate your efforts.

    Thanks,

    Jim

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-06-06T20:32:07+00:00

    Thanks Jim:

    I've added your comments here to the UserVoice forum. Let's see if that helps this point to be taken. 

    In the meantime, I'd have to do some magic with PowerBI and create some conditional columns for detecting delayed tasks.

    0 comments