Description:

Currently, ClickUp’s formula custom fields can only access the total time tracked on a task, with no ability to filter or sum time entries by date or date range. This limits reporting and automation capabilities, especially for organizations that need to analyze or display time tracked within specific periods (such as the current calendar month, week, or quarter) directly in task views or dashboards.

Requested Enhancement:

Allow formula custom fields (including AI-powered formulas) to reference individual time entries, not just the total.

Introduce formula functions or AI logic that can sum or filter time tracked based on a specified date range (e.g., only time tracked in the current month).

Enable dynamic date filtering using functions like THIS_MONTH(), LAST_MONTH(), or custom date ranges within formulas.

Ensure these enhanced formulas can be used in List/Table views, dashboards, and reporting widgets.

Benefits:

Enables more granular and automated time reporting directly in ClickUp.

Supports common business needs such as monthly timesheets, project billing, and performance tracking.

Reduces the need for external exports or manual calculations.

Leverages ClickUp’s AI and formula capabilities for smarter, more flexible reporting.

Example Use Case:

A formula custom field that displays “Total Time Tracked This Month” for each task, automatically updating as new time entries are logged.

Suggested Formula Syntax Example:

SUM_TIME_TRACKED_IN_RANGE(start_date, end_date)

or

TIME_TRACKED_THIS_MONTH()

Summary:

This enhancement would make ClickUp’s time tracking and reporting much more powerful and flexible, especially for teams that rely on accurate, period-based time data.