Help

To Do List base, want to calculate time left in non-completed tasks

Topic Labels: Formulas
910 2
cancel
Showing results for 
Search instead for 
Did you mean: 
John_White1
4 - Data Explorer
4 - Data Explorer

I have a To-Do List sorted by department with the estimated time to complete each task in a daily view.
I want to surface the time left to complete tasks marked in progress, not started, pending.
Is there an easy trick I’m missing?

2 Replies 2

Hi @John_White1
I think you can do this with a few formulas

image

Here is my Due Date formula, this looks to see if the Due Date is a weekday and if not assigns the next available weekday:

WORKDAY(DATEADD({Assigned Date}, {Days to complete}, 'days'), 1)

And the Days remaining formula:

IF(OR(Status="In Progress", Status="Not Started", Status="Pending"), DATETIME_DIFF({Due Date}, {Assigned Date}, 'days'), 'Complete')
John_White1
4 - Data Explorer
4 - Data Explorer

Fantastic formulas! Thanks for this.