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?
