Forum Discussion
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...
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.
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?
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.