Need to be able to calculate days and return a date field in a custom formula; something extremely basic like "due date -7 days" is not currently possible.

We need to specify the weekends for the date and time formula

In ClickUp, it is Saturdays and Sundays by default.

Requesting the addition of the IFS advanced formula function; would have saved me 90 mins today from not having to overload automations.

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.

Generally, the syntax for the IFS function is:

=IFS(logical_expression1, value_if_true1, logical_expression2, value_if_true2, logical_expression3_value_if_true3)

In my use case today:

Field A is a Number

Field B is a Number

Field C is a Formula = Field A * Field B.

Those three fields work well today.

Field D is based on the value of Field C, where

If Field C is less than 13, then Field D is 'Low'

If Field C is greater than or equal to 13 and less than 20, then Field D is 'Medium'

If Field C is greater than 20, then Field D is 'High'

It would be great in the future to easily say:

IFS(fieldC < 13, 'Low', AND(fieldC >= 13, fieldC < 20), 'Medium', fieldC > 20, 'High')

Thanks for your consideration.

Currently, in our task process we put a start date in for a task and then we have to set up dates for 3 rounds of QC. Right now in ClickUp we use a formula based on the start date to automatically add the QC due dates. The issue is if we need to change the QC due dates but leave the start date where it is we cannot manually change the QC dates because they are formula fields. It would be very helpful to have the QC dates populate based on the due date rather than the start date. In order to do this we need to be able to use negative numbers in the formula field which is not possible now.

Need the WORKDAY function to support negative times.

This only works for +ve lead times.

Required by date = Required Date - lead time (this is not work)

WORKDAY(field("Required By"),-field("Lead Time"))

If I drop the "-ve" sign it works. However, that gives the wrong result.

Please expose field("Name") to advanced formulas. The string functions (regex, search, etc) are pretty much useless without being able to access the Name field. It would be really nice to have conditional logic based on text descriptions in tasks. Current use case: I have milestones in a task list and add subtasks to reach the milestone. I can create an Age of task column easily with today()-field("Date created"). But since all the milestones were created at the same time, that's not useful and I'd like to suppress milestones. Could do this if a function like IsType("Milestone") was available. But without inventing a new function, simply exposing the "Name" field would completely solve my problem.

Please please get rid of the "field()"

Just make it the field. with complex formulas, this can be difficult to view, build, troubleshoot

Looking for ISBlank function and/or CountBlank work outside mathematical context.

Use case: looking to check is certain fields are populated

I would like to group and filter formulas based on the return value type (number, date, etc.).

In the case of dates which are calculated (ex : next birthday) I would like to be able to group dates (Future, This week, passed) and filter dates (this month).

This is very useful in order to display a list, table or calendar to a Wiki for example.

Caroline Ginty

-Please modify the UI to allow for a larger editor