-
What exactly trigger different alerts? The labels stink!
Alert 1: If you select Create a new rule and Alert Someone you receive a pop-up that has a top line of 'Trigger: When a row is added or changed" and the next line is When Any field changes If I press Save I see the alert with a description of 'When a row is added or changed' but nothing about any field being changed. When…
-
Reference in comments mail
When a comment is posted directed towards another user, the resulting email only mentions the row number. Is it possible to have a column value (eg. task title) as reference in the mail?
-
Alert based on row deletion
Hello All, Is there a way to setup an alert that has the following conditions: IF row on 'X' sheet is deleted by anyone but 'Y', sent alert to 'Z'. I thought about creating and alert that said if row is deleted alert 'Z' if 'modified by' is not 'Y'. It doesn't look like I can do this though as the work-flow parameters I…
-
Why am I receiving automation email replies?
I set up an automation that will send a PO request to external clients. When they reply to the automated email it comes to my email address and not the person that was requesting the PO. 1. Does it come back to me because I created the automation rule or because I own the sheet? 2. If I sent an update request instead of an…
-
Auto-populating dates
I have several categories in my 'Status' column. (Sprint Backlog, Planning, In Progress, In Review, Changes, Print Files Ready, Print Req Sent, With Printing Services, Complete, Blocked) I would like to have a date automatically populate when the Status becomes 'In Review'. Then, once that date is populated, and if the…
-
How to update rows from a custom form...
Hi, I have a Smartsheet that contains information about different pieces of work. Each row is specific to a piece of work and it has multiple columns, one of these is Status. I display this as a Kanban using Card view. When I change the status of an item to Completed, I want to automatically send a form to a contact in one…
-
Mass contact upload without notifying
Morning community buddies, I am looking to upload all of my companys' contacts into Smartsheet for two reasons: 1) So anyone in the business can appear in a contact drop-down - as some may not use Smartsheet but we in the PMO would be able to track resources - free text could lead to mistakes so it needs to be the same…
-
Old Notifications
There is an old Notification going out to my Team, I created this a while ago and want to edit it but I can't find it in my Manage Alerts ^ Actions menu. I made note of the Notification ID that is being sent out. Is there any way to search for this Notification by ID? Or how else can I find this notification so I can edit…
-
Update Requests History
HI There when we ask for an update and there is a response you see the response within the comment but you cant see what was asked for the update. Is there a way to do this? Thanks Abbie
-
Mandatory or Required fields to complete in a smartsheet
I have a need for users when updating or entering data in a cell in a smartsheet that they must complete some mandatory fields. A webform has this function, however on existing rows it would be ideal to have users who are given updates or entering in a new row to have to complete some mandatory fields before final saving…