-
Notification
Hi all, I need some help... Whilst I am of the understanding that you can set up notifications when a user makes any changes to a sheet, is there any way you can be notified if someone has in fact opened a sheet they have been invited to view? Thanks in advance
-
Notification gets sent AGAIN when I make additional changes to a row
My Smartsheet tracks employee travel. They complete a form to request approval for travel, and then I go into the Smartsheet to approve it. I have a notification set up when I approve based on adding the "date approved," and an approval is sent to the user. However, when I go back later to add the final travel amount…
-
Sending multiple sheets as one attachment
Hi All, Is it possible to send multiple sheets (all in the same workspace) as an attachment? The reason I ask is I have 8 reports which will all need to be sent on the same day each month and I was hoping to avoid having the the client recieve 8 emails each time. Pdf of excel is fine Thanks, Soph
-
Forms and formulas
Hello, I am new to Smartsheets and am creating a form to send out and collect orders from customers. Now the form works but I need it to populate the new rows that get added with pricing from another sheet. Is this possible as I am not finding any info on this but then again I am new to the site. I would also like to know…
-
Status auto change
Hello, I was wondering is it possible to make the status RYG color changes when it is closer to the due date? For example: it shows red when it is due two days before the date and so on... Is there a formula to right and what is the formula? Thanks a lot
-
Reminder Notification Emails
Is there any way to customize what columns I see in reminder emails? We had a client which recently took control of a worksheet we've been using and I no longer have admin rights. Before, I had made a "dummy" conditional column to change when needed, then I would send myself a nice clean Notification. So is there any way…
-
Alerts/Notifications based on cell color
I would like to create an alert. If a cell turns red in a delivery date column, email PM assigned to PM column and another editor within the sheet. Do not see how to establish an alert just based on change of color.
-
How to change the sender email address when Sending Link to Form?
We use a web form as client survey but when sending it typically goes to the client's junk/spam folder because it's coming from "John Lee via Smartsheet <user@smartsheet.com>" instead of my email address which they have already interacted. This is negatively impacting our ability to communicate with clients as we have to…
-
Formatting with alerts
I need to do the combination of formatting with and alert, but seem to have hit a wall. If column "delivery type"= selection "o" and column "1st delivery" has a date that is past due then turn "1st delivery" to red and send an alert to the contact in columns "PM" and a particular individual. Any help would be appreciated.
-
Receiving Reminders Not Receiving Notifications
Hi, I have an email address ("Support") shared to the Workspace. It is receiving reminders (reminder@smartsheet.com) but it is not receiving notifications (notification@smartsheet.com). The notifications are not going to junk mail. Nothing was on the "Safe" list of the "Support" box but reminders were coming in. I added…