We currently track our team’s billable hours, non-billable hours, and total hours in an external Master Sheet. In that sheet, we use formulas (e.g., =SUM(Total Hours Tracked / Total Billable Hours) * 100) to calculate monthly and weekly utilisation percentages, compare against targets, and report on progress.

I’ve been trying to replicate this in ClickUp dashboards, but the current calculation widgets don’t allow the same level of flexibility as Excel/Sheets. Having formula fields in dashboards would remove the need to maintain a separate external Master Sheet and would allow us to keep everything centralised in ClickUp.

This feature would be a huge improvement because:

It would let us monitor % Actual vs % Target utilisation directly in dashboards.

We could track hours by week/month with live data rather than manually updating spreadsheets.

It would reduce duplication of work and make reporting more efficient.

Clients and internal teams would have clearer, real-time visibility into hours and utilisation.

Overall, the ability to add formula fields and apply them in dashboards would streamline workflows, cut down on manual admin, and ensure our reporting is accurate and consistent.