What can we help you with?

e.g. Gantt chart, Creating tasks, Sharing folders

Blog

Task overdue by how many days ?

10 comments

  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Anna Wallace

    Hey Eli! You can do this using the reports function.

    First, make sure that the custom calculated fields feature is activated in Wrike Labs. You can do that here:ย https://www.wrike.com/labs/

    Then, create your report with all of your filters and specifications. In the report view, click on the cog icon in the top left-hand corner, then click "Create Field" at the bottom of the pop-out menu.

    Name your new field and paste this formula into the box that appears:

    [Due Date] - TODAY()


    Any negative number is how many days the task is overdue! I hope that helps! :)

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Trevor Tollefsbol

    Hi Eli,

    Make sure you have calculated fields enabled in Wrike Labs.

    Setup your report by filtering by "Overdue" under Tasks To Do.

    Then create a Calculated Field using the following function:

    The resulting report should give you the information you're looking for.ย  Let me know if this helps.

    Cheers!

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Trevor Tollefsbol

    Hi Eli, I've submitted a comment with screen shots that is pending approval.ย  Hopefully you'll see that by the end of the day.ย  The short version is to use a calculated field in your report with the following function: Today () - [Due Date].

    Cheers!

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Trevor Tollefsbol

    LOL!ย  Hi Anna, looks like your comment wasn't immediately posted either.ย  I didn't mean to follow on your heels with the same info, but happy to see we're using the same steps!

    Cheers!

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Anna Wallace

    Haha! Hey Trevor! Yep, we are both spot on, aren't we? ๐Ÿ‘ Great minds think alike!

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Glyn Thomas

    This is great and thanks all.ย  Outstanding question is can you set the Days Overdue to be just Days and not include hours and minutes?

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Lisa

    Hi @Glyn! Can you please post a screenshot with the minutes and also let me know whether it's a task or a project where the minutes are shown? Thanks!ย 

    Lisa Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Glyn Thomas

    (Edited )

    @lisaย  Responded via Email with a screenshot.

    Task orientated report.

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Glyn Thomas

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Lisa

    Hey Glyn Thomas, thanks for the details here. I can see that you've discussed this with our Support. For now, it's not possible to hide minutes. We've recorded your feedback (thanks for providing it!), it will be reviewed by the team.ย 

    Lisa Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 0
    Comment actions Permalink

Please sign in to leave a comment.

Folllowing List for Post: Task overdue by how many days ?
[this list is visible for admins and agents only]

Community

Welcome ๐Ÿ––

Hi there! ๐Ÿ™‚ Want to become a black belt Wrike Ninja? Here's how to earn a Wrike badge

Welcome ๐Ÿ–– Have you checked out this week's Release Notes yet?

Hey! ๐Ÿ‘‹ Curious about something? Visit How To to search and ask the Community for answers.

Welcome! ๐Ÿ‘‹ Figured out a good tip or trick? Share it in Best Practices.

Want to connect your existing software to Wrike? Learn and ask how in the API section.