Modified & Create Date column

I'm trying to create a report that will show me what has been modified or created in a sheet in the last 7 days. I know I can highlight changes but I would rather just have a report show me what has changed from the sheet.

I'm running into problem with this not working correctly and I don't have the permissions on the source sheet to add columns (nor will the owner add any columns for me).

Is this due to the timestamp in the system-generated columns (Created & Modified)?

Has anyone been able to do something like this?

Any input would be appreciated.

Thanks -Peggy

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!