Cell linking effecting Last Modified date for whole sheet

Clayton

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? 

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

 

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.