Task Type Detection in Formula Fields
Sergio Sapuppo
Summary
Add the ability to detect if a task is a parent task (has subtasks) or a regular task within Formula fields, to enable dynamic calculations based on task hierarchy.
Current Limitation
Currently, Formula fields in ClickUp cannot automatically detect whether a task contains subtasks or is a standalone task. This makes it impossible to create formulas that behave differently for parent tasks vs. individual tasks without manual intervention.
Use Case Example
Scenario: Calculate "Estimate at Completion" dynamically
For parent tasks: Sum of all subtask estimates
For regular tasks: IF(field("Completion Date"), field("Tracked Time"), MAX(field("Tracked Time"), field("Estimated Duration")))
Log In
K
Kristian Mainella
I fully support this request: it would significantly improve flexibility and automation in the use of Formula fields.
Gabriele Vitale
Strongly support this feature request. This would be a huge improvement, being able to detect whether a task is a parent or a regular task in Formula fields would unlock much more powerful and automated reporting