Forum Discussion

knishal's avatar
knishal
Regular Visitor
3 years ago
Solved

Show OverDue Task - Sharepoint Task List

Hi I am using a sharepoint task list to visualize data. I would like to create two additional column to view overdue task and completed task. I got the following error:     Any help wi...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    3 years ago

    Hi knishal ,

     

    Maybe this formual

    =

    VAR _D=DATEDIFF(TODAY(), Tasks[DueDate], DAY )

    RETURN

    IF(_D<1,"OVERDUE Task",_D)

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

knishal's avatar
knishal
Regular Visitor
3 years ago

v-chenwuz-msft  that works but shows "1" how can I display the amount of days it will be due in?

 

This is what I use: 

UpcomingTask = IF(MAX(Tasks[DueDate]) >TODAY(),1,0)

 

 

knishal's avatar
knishal
Regular Visitor
3 years ago

v-chenwuz-msft I currently have this formula which shows the amout of days its due by:

 

OverDueTask = DATEDIFF(TODAY(), Tasks[DueDate], DAY )
 
How can I modify it to show only OVERDUE Task and the day count?
 

 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    3 years ago

    Hi knishal ,

     

    Maybe this formual

    =

    VAR _D=DATEDIFF(TODAY(), Tasks[DueDate], DAY )

    RETURN

    IF(_D<1,"OVERDUE Task",_D)

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.