Error Catch of Weekdays Left when Due Date Empty

Platform discussions Special workflows & use cases
1

I am having a hard time making this formula work. I can make it work if i simplify the main equation that i want to use. The formula works on its own but returns errors when due date is empty.
Only have a “Due Date” field and “Days Left”. Want Days Left to be workdays only. and want to show No Date or 0 if “Due Date” empty.

IF({Due Date},(ROUND(DAYS({Due Date},Today())-(2*(WEEKNUM({Due Date})-WEEKNUM(Today()))),1)),“NO DATE”)

Thanks in advance.

2

@sfederle

Due to the way that monday formulas are processed, even functions that are not needed are sometimes calculated. In your case, though the DAYS() and WEEKNUM() values do not need to be calculated when {Due Date} is blank, they are. And therefore they will always need to be able to be calculated.

This should get you closer:

IF({Due Date},
  ROUND(DAYS(FORMAT_DATE(IF({Due Date},
    {Due Date},"1/1/1")),
    FORMAT_DATE(Today())) -
    (2 * (WEEKNUM(IF({Due Date}, {Due Date},
      "1/1/1")) -
    WEEKNUM(Today()))), 0),
  "NO DATE"
)

Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or Excel)

3

This works great and i see what you did there. Thank you for your Help!

1 Like
4

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