Seeking a formula to return a percentage of completed tasks across a specified timeframe

tminuk14

I have a sheet with rows of data that each represent individual completed requests from across my org. I have a status column with dropdowns like completed, under review, assigned, etc. and a date closed column. I would like to create a metric for my dashboard that shows what the percentage is of requests that have been marked as completed in a given timeframe [ex (2025, 1, 1) to (2025, 3, 31)[.

Request	Status	Date Completed
Request 1	Complete	1/15/2025
Request 2	Under Review
Request 3	Complete	2/1/2025
Request 4	Complete	2/15/2025
Request 5	Assigned
Etc
Etc

I have a working formula that counts the number of completed requests in a given timeframe, but the output does not result in a % that I can use for my dashboard. 

=COUNTIFS(Status:Status, CONTAINS("Complete", @cell) = true, [Date Closed]:[Date Closed], >=DATE(2025, 1, 1), [Date Closed]:[Date Closed], <=DATE(2025, 3, 31))

What formula would work to return a single percentage for completed requests across a timeframe?

Adam Murphy

You would need a count of total requests (including the completed one), the divide Completed/Total. Hope this helps!