There is a good option to review changes in last say x hours and day , I would like to know how to copy all rows where last changes happened for that filter to only copy and paste to someone asking for delta work for last say 7 days ?
If I'm understanding you correctly, you want to Copy Rows from one sheet to another sheet if a date is within a range. It sounds like you could use the Copy Row workflow with some Conditions set.
See: Automatically Move or Copy Rows Between Sheets and Condition Blocks: Filter What Your Automated Workflows Send
If this hasn't helped, it would be useful to see screen captures of your sheet, with a bit more information, but please block out sensitive data.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
©2022. All Rights Reserved Smartsheet Inc.