Hi, I'm new to MS Lists & Sharepoint so I apologies if this is a simple fix. I've created a column in MS Lists which lets me know when a task is overdue and works well but... Is there a way that this 'days overdue' column updates automatically when I log in to MS Lists, or even a one touch refresh, at the moment it will only update if I edit that section which is time consuming going through each task & really pointless to have it.
I believe I have to create a flow, but haven't a clue how to create one.
HI @petern19
How are you checking if it's overdue? Is it a calculated field?
I would create a calculated field with the following formula:
=IF([Test Date]<TODAY(),"Elapsed","On Time")
In this case, my column is named "Test Date". Here's the result:
Can you please check if and let me know if you have any questions?
Cheers
Manuel
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Thanks Manuel,
This is the formula I'm using,( below) would yours update every time I log in, or would I have to do manually for each task? I'm really after an automatic update each time I log in rather than changing each task every day. Someone suggested I create a 'flow' but have no idea how. If I can't find a solution, then I may use your formula as at least I don't have to update each task every day.
=IF(LEN([Est Completion date])=0,0,IF([Est Completion date]<TODAY(),DATEDIF([Est Completion date],TODAY(),"d"),"-"&DATEDIF(TODAY(),[Est Completion date],"d")))
hi, do you have a solution to that? i have similar problem faced today.... while applying TODAY function, finding sharepoint will not auto refresh the datedif value... poor..
User | Count |
---|---|
22 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
43 | |
28 | |
25 | |
24 | |
23 |