Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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?
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
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
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?
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.
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
