-
Creating Alert to Notify Users Once Agreement Signed
Hello, I am trying to create an alert that would notify users once an agreement has been signed. I have watched some Smartsheet videos but I'm still a bit confused on how to create one. Why might the “Automation” button not appear near to “File” button even though I am the Smartsheet owner? See the attachment.
-
Do reports trigger alerts?
Hi all, I am wondering if accessing a report will trigger an alert from the source sheet? I have an alert set in my sheet that triggers based on a formula. If someone accesses a report that is based off this source sheet, will the alert still go out? Thanks in advance!
-
Need advice on Forms & Approval Workflow
Note the word “form” below does not necessairly mean a Smartsheet form…currently it’s a Word doc * I have a form that need to be completed by at least 2 people. * Once complete, the form need to be reviewed by 1 person* If correction needed return to step 1 * If correct move to step 3 * Form is sent for “approval” to 5-6…
-
Account email notifications from Smartsheet
We have a few others set as administrators for on our account. I would like to modify who receives notifications from smartsheet, ex. User has requested to be a licensed user email notifications. I would like only 1 administrator to receive these types of account notifications. Can this be done?
-
Connect email notification with smartsheet for specific users
Hello, i was looking to create a new project using smartsheet to receive alerts from specific email addresses and to log the activities into smartsheet, those notifications will be received by specific users (their email addresses). how i can start implementing that and is it doable or not? Thanks!
-
Notifications, Report or Dashboard
i am new to smartsheet and using it to keep track of inventory across multiple locations which have different contacts by location. What is the best method to send a scheduled listing of assigned assets to each contact owner. Would like them to only see their assets and be able to change the location if they no longer have…
-
Exporting Contact Emails in Sheet to Excel
We have a contact column in our sheet with names and email addresses. I would like to export that information into excel but it will only export the names. Is there a way to get the email addresses?
-
Automated Workflow - Invalid Date Error
I have set up an automated workflow to trigger when status changes to complete if date field is greater than 12/31/18. I am able to choose the date but it changes to "Invalid date" when i save the workflow. I thought maybe since the date field i was using is an automatic number field, it didn't recognize the field as a…
-
IF Statement - If two columns match any two columns on the page, flag it
Right now I have =IF(COUNTIF([Part Number]:[Part Number], [Part Number]1) > 1, 1) If the part number in row matches up with another row, it lights up a flag. I want to be able to add two checkpoints... If a "part number" and "ware" in one row matches up to another "part number" and "ware" on a different row, light up the…
-
Update requests to more than a person
Hi all, I have a spreadsheet that has set up an "Update request". Now, that same update request was set up to notify both myself and my colleague (since i was on annual leave recently, so nothing was getting left behind). What happens is, since there are 2 people in the automation, the update request only gets cleared…