This is a fundamental formula- and I hope a quick fix!

In case it helps someone, my scenario was that I wanted to check if Date field was blank and if true, return "Missing Date".

My workaround was: IF(COUNTBLANK(field("Date"))=1, "Missing Date")

The COUNTBLANK() counts the number of blank values, so if the field was blank it would return 1.

Ok superagents but we should also care about minor and easy to fix features like this.

This is a must because when exporting to excel it is showing incorrect information so it is an issue. Data in a table with a formula based on dates where one of the values is in blank, is different in the table and int he excel

I've created a CRM on ClickUp, where one of the fields is "Birthdate". I want to calculate the current age of my contacts but, as I don't have the birth date of everyone, this is currently the result (see the attached image). To be able to use a formula like "ISBLANK" as something absolutely essential, not only for this example but for so many more situations. Please add this functionality as soon as possible. Without this, the use of formulas is very limited...

Agreed, conditional date checks is critical for measuring the actual cycle time of a project where a delay was observed. It is impossible now to construct an IF statement that can bypass this limitation.

Please please please place priority to fix this over any new feature. Profits, financials, dollars, all used to work without issue for all of 2024. Then right at the end of the year when we need to do our annual accounting review, errors all over the place and can't see anything.

It looks like you can use LEN() to check if a field is empty

This used to work perfectly but is now returning a "Formula Error." It’s incredibly disappointing, as this was a key feature of our workplace, helping different teams automatically calculate deadlines based on the due date of a task. Its functionality was crucial for streamlining our workflow, and losing it has significantly impacted our efficiency.

This was possible before but now with formula changes it is not possible any more and throwing an error on all subtasks. We use the formula to calculate rolled-up time estimates vs. capacity (custom field) on parent task level. The formula does not apply to subtasks but now it shows the useless error message on every subtask.