"Last Update" to look for last manual update, not last formula update

I currently have a column that counts how many days until the due date. Because this column formula utilizes "TODAY()", this means the column re-calculates every single day.

Because of this, my "Last Updated" auto-fill column always lists today (or the last day I opened the sheet) as the time the rows were last updated.

Is there any way to make the "Last Updated" column only count a manual cell update rather than an update based on a column formula?

I want to be able to use the "Last Update" column to request an Update if an update has not been made to the row in the last 7 days, but because of this formula, they never are reaching the 7 days to trigger that request, even if manually they haven't been updated in more than that.

Find more posts tagged with

Formulas

Automations

Update Requests

update column

Accepted answers

Paul Newcome

My suggestion would be to insert a date type column then use a record a date automation set to trigger when one of those manual fields changes and records the date of change in the new column.

All comments

Ray Lindstrom

@LesGos,

There's no way to differentiate between a manual and a formula update when using the Last Modified Date.

You might consider using a Sheet Summary field for the Today() function. If you were to name the column Todays Date, you would reference it in formulas by [Todays Date]# instead of [Todays Date]@row.

Hope this helps!

BRgds,
-Ray

LesGos

Good idea! I have updated to that to see if that will help it. Have to wait until tomorrow to see, though.

Paul Newcome

My suggestion would be to insert a date type column then use a record a date automation set to trigger when one of those manual fields changes and records the date of change in the new column.

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.