Formula Error Help - Days left until due date

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

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?


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

Thank you so much! That worked perfectly.

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