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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.