Dynamic reporting period
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