-
Automated Alert & Action Issues
Hello I am trying to solve an issue with a system I have set up for Automated Alerts & Actions. See screenshots below. As you can see by screenshot 3, I have created a trigger column based on date surpassed; once that date is surpassed the cell will change from N to Y. The idea ultimately is when it changes to Y it…
-
Use a form to lookup sheet data that and add content to it
Hello, I have read the forms with the “VLOOKUP” and “LOOKUP” functions. I am new to smart sheet, but not to excel formulas. I have an associate inspecting carts for wear and tear items, this is working well with check boxes and the photo attachment is awesome to have. Next step is the associate that repairs the cart, I…
-
Highlight Colours
Hello, I have an 'Alerts & Actions' when a row is added to email out many cells. When this email arrives in my staffs inbox the cells are bright yellow. Is there a way to change the colour? - I would ideally like a less bright colour? Any help would be wonderful. Thanks Matt
-
How to setup a notification for less than days
Hi, How can I setup a notification for a column that date is less than days ? like 60 days. thanks ! Nova
-
Notifications not working?
I set up a Notification earlier today and it is not working. Is there an issue with the Smartsheet currently?
-
Automated Alerts & Actions
OH MY! You all are so close... I've been waiting on the day that I could save my alerts and notifications to a template for over a year now. On average, I create about 10 new sheets every week, and each sheet consists of 2 REMINDERS and 8 NOTIFICATIONS. We use these sheets to track new parts to be manufactured, and once we…
-
System Field: Date/TimeStamp behaviour
Hi all, Have been a fan and avid user of SmartSheet since 2015. Great to see all the continual roll out of new capabilities / functionality. I am currently working on building a triggered notification on SmartSheet -- essentially, if a specific row has not been updated for "x" days, it will fire a notification to a…
-
Send notifications "daily" or "weekly", but not in middle of night
Is there a way to not have smartsheet notifications sent at 2:00am? (e.g. on call people have to have their email notifications audible 24/7) I'm afraid the time of day these types of notifications are sent are set on a global level, correct? Any workarounds? I would love to be able to have these be sent daily at 8:00am -…
-
Notifications for Comment Updates
Hey SS community, Our company is looking to phase out Basecamp and solely use Smartsheet to manage our ERP implementations. One feature that keeps us holding on to Basecamp is their UI for discussions. For those who have not used Basecamp, a feature we are partial to in discussions is the ability to choose who receives an…
-
User Email to update status in smartsheet
Dear Smartsheet users, can I use an email to update a status? We create a ticket in Smartsheet - then we send it to a ticket system. A status update will be provided back to smartsheet and should update the status from new to done. All I found was just creating a new entry in a sheet upon email entry. Regards, Christian