-
Outlook App and Date Column Error
I am using the Outlook app for Smartsheet (which I love!) but when entering info from Outlook, I am unable to edit a date column if there are more than one in the sheet. Ex. If I have a Start Date and Finish Date for a project, I can only edit the Start Date column from Outlook. The Finish Date field is grayed out. Is…
-
Ticketing Sheet: Update Request to Group?
I'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on tickets at different times of day. How do you request an update to a ticket (row)…
-
How can you edit a collborators e-mail address?
I want to edit an e-mail associated with a collaborator because it has changed. There seems to be no way to edit anything in the Sharing area. I know how to edit My Smartsheet Contacts, but that doesn't help. Sometimes the collaborator contact doesn't show up in My Smartsheet Contacts. Even if it does, and I successfully…
-
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.