Cell linking effecting Last Modified date for whole sheet

I have a Main sheet with a cell that is linked to a log sheet to count total rows. whenever a form user adds a row to my log sheet it is updating the last modified date for all the rows on my main sheet. any idea how I can have this stop happening so I can send out a notification for any row that has not been updated in last 24 hours on my main sheet?

Find more posts tagged with

Forms

Manufacturing

Project Management

Cell linking

Email Notifications

Comments

Andrée Starå

Hi Clayton,

Do you have formulas on the main sheet that is affected by the cell link from the log sheet?

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Clayton

Thanks Andree,

I have what is below in "rounded date" and if today Green for "updated?" but nothing is pulling from my cell linking in Maintainace log count.

=IF(RIGHT([Last Updated (auto)]29, 2) = "AM", DATEONLY([Last Updated (auto)]29), DATEONLY([Last Updated (auto)]29) + 1)

not sure why everything row got updated at to the same 5:05 am time with the first request for maintenance of the day.

I need to auto trigger an email to area owners if they don't update me within 24 hours is my goal

main sheet today.png

Andrée Starå

Happy to help!

Can you share the sheet or a copy of the sheet with me?

Would it work if you've set up a daily update request that would trigger if the area owners haven't confirmed?

Paul Newcome

if today Green for "updated?"

The TODAY() function is triggering the "update". If all you have in there is that it is Green if it equals today, then when it is not today it will change to a blank. That change is considered a "modification" which will reset your Last Modified Date to Today. Since Today = Green, it will now switch back to Green. It is another "modification" to the row, but because you are only comparing the date and the modification takes place almost instantaneously, it will appear as if the Last Modified was when you first opened the sheet for the day.

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…