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 am tracking vehicle maintenance for our corporate vehicles. I want to set up a rule that will send an email alert when a repaired checkbox is goes unchecked 7 days from the reported date. There is an option for "in the past (days)". But that doesn't seem to work if the repair date doesnt fit within the "x" # of days you put it. I want it to send an alert it goes unchecked greater than 5 days.
If the sheet gets opened daily, you could add a checkbox column and enter
=IF(AND(TODAY(-7) > [Reported Date]@row, [Repaired Column]@row = 0), 1)
This will check the box if the two criteria are met. You can then base your alert to send for when that box is checked.
worked great! exactly what I was looking for.
Thanks!
SGF
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…
