I'd love to be able to reference the List and Folder where a task is located in custom field formulas. Currently this isn't possible, but it would be incredibly useful for our workflow. We use each Folder as a client name and each List as a project for that client, so being able to auto-populate custom fields based on task location would save us tons of manual work.

Just want to add my voice to the call for this feature. I need to be able to use dropdown field values as conditions to calculate the earliest possible start date for a project.

It's confusing to the user when this DOESN'T work - it makes no sense to an end user that you can only use numeric or date fields in a formula.

Rollup fields too please🙏

Is there a timeline on this feature yet?

This would be great – my use case is, that I use "My Dropdown" with options like …

1 – none

2 – some

3 – many

… and I would like to use the first character in a formula to calculate a score; seems as if all the gears are already in place – LEFT(field("My Dropdown"), 1) * 1) – but it won't let me use field("My Dropdown") in the formula, unless all the option values are numeric.

Is there an update on the timeline for this? Again, this is where it's hard to justify ClickUp to Executive when Notion has so much formula functionality and is about to introduce granular database permissions; especially when ClickUp doesn't allow estimated and tracked hours to be converted to dollars by each employee's charge rates via built-in COTS functionality - at least being able to do this via self-built formulas would offer a workaround.

Can the formula window be much bigger? It is frustrating to be constrained to such a tiny window.

if(fields("some checkbox"),true, false) would be super useful

Would be great to be able to use custom date fields as triggers as well!

it would be really awesome being able to do stuff with formulas based on assigned /subjective "Priority", even if found un-set.