Modified & Create Date column

Peggy Parchert

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

Mike Wilday

I am pretty sure you can't pull WHAT changed, only the rows that changed. Using the system generated column of modified. You should be able to pull anything from the last 7 days.

Peggy Parchert

@Mike Wilday

I thought so too but I know for a fact one line item had multiple columns changed today and the Modified column didn't change. So I'm at a loss as to why it's not working like I thought it would.

Mike Wilday

Hmmm. Were the changes saved? Are the modified dates updated to today's date? Can you share a screenshot of the original sheet and your filter settings in the report builder without exposing any critical information?

Peggy Parchert

@Mike Wilday - Ok if I email you directly?

Mike Wilday

Yes,. that would be fine.

DavidTrask

Hi @Peggy P , I'm trying to create a similar report or add just changed rows to a dashboard. Any success?

Peggy Parchert

No - I have a ticket open with Support. I will make sure to post what they say on this thread.

Thanks -Peggy