Formula Error Help - Days left until due date

Platform discussions Special workflows & use cases
1

I watched a tutorial on due date vs. completion date and if the task is on time or overdue. If the task hasn’t yet been completed, my formulas are returning an error that says “One of the parameters is invalid”

My Days left formula is
ROUND(Days({Due},{Completed}),0)

My On Time? formula is
If({Days Left}<0,“overdue”,“on time”)

Is there a way to either have the error not show up as to declutter my board, since the formula works once there is a date in the completed column, OR if there is no completed date to show how many days are left until the due date in the days left column?

image
image708×264 14.7 KB

2

@SarahS

Change your first formula to:

IF(AND({Due},{Completed}), ROUND(Days({Due},{Completed}),0),"")

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas: the SECRET Functions

3

Thank you so much! That worked perfectly.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.