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({D…

@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

Formula Error Help - Days left until due date

Platform discussions Special workflows & use cases

system (system) Closed December 20, 2021, 2:10pm 4

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

Topic		Replies	Views
Countdown date Formula error Platform discussions formula	3	2113	June 7, 2021
If function based on status column, calculate days Special workflows & use cases formula	2	19	January 29, 2025
Formula specific to date in the past, on time, late or overdue Platform discussions formula , date	0	285	May 8, 2024
Formula for Overdue using timeline column Special workflows & use cases formula	7	5922	August 11, 2021
Formula or Automation to Calculate Overdue Tasks Feature requests automations	2	2126	September 30, 2022

Formula Error Help - Days left until due date

Become part of our community groups

Can't find what you're looking for?

Can't find
what you need?

Formula Error Help - Days left until due date

Related topics

Become part of our community groups

Can't find what you're looking for?

Can't findwhat you need?

Can't find
what you need?