Dynamic reporting period

Hello everyone,

I think that I have a simple use case but I can't find how to implement it in Smartsheet

I have a sheet with commercial tasks (send quote, contact leads, negociate, contract signed, etc.)

Each time a commercial task is fulfilled I put the date in another column.

I created apart a metric sheet and I would like in this sheet just write a start date and end date, and it could give me all the commerical actions that have been made on this period. Then I could split by type, client, and so on.

Do you have an idea of how to create this mecanism ?

Thank you for your time, have a nice day