-
Daily Notification
Hi All, Is there a way to send a daily notification when a task is not complete? The way my sheet is set up is the RYG dots are automated depending on the due date, and based on those dots, notifications get sent (Yellow is the due date, Red is overdue). What I would like to do is once the dot turns Red, to have a…
-
Looking to set Notifications/Reminders beyond the default options
Hello - I'm a bit new to Smartsheet but loving it so far. I have a few columns with dates that I would like email notifications or reminders set up when the following conditions occur: 1 year anniversary from date in cell 5 years, 9 months after date in cell, IF another cell has a certain value 9 years, 9 months after date…
-
Changing Distribution List on Recurring Emails
I have a sheet I created that auto sends every Monday at 4pm to a specific group - many of whom dont have access to the actual sheet. I want to add someone new to that group - do I have to redo the whole thing? I dont seem to be able to edit the distribution list. Thanks!
-
Criteria for Alerts and Actions Rule
My boss has a Smartsheet set up to send a Update Request 30 days before today. For example row 7 would look like ....=[Due_Date]7 - TODAY() Would this alert still be sent if Smartsheet was down for maintenance at the scheduled time the alert was to be sent, or if there were conflicting "work week/full week" settings?…
-
G-Suite reply in comments
I successfully have my emails in Gmail landing in the comments in a particular or new line in a sheet, works great and very helpful. I see in the added email in comments a "add reply" blank. Does this reply just stay with the comment or does it go back out to an email Maybe this is a wish list type of thing, but if a…
-
Creating Different Update Request Formats
I send update requests every day. However, when I send them, I have to keep removing some of the columns as those that I remove are not necessary for the person to see. Is there a way that I can save an update request format with those columns removed so I can quickly choose the right formats for the specific person I am…
-
What to do when project ends?
Hi Smartsheet Community, Our company works with customers on projects for a set period of time. When a project is complete, we archive completed projects for internal use, but we no longer need our customers to view or edit sheets and sights in Smartsheet. When a project ends, is there is way to inactivate or close our…
-
Email Notification View
We use Smartsheet notifications and receive emails frequently letting us know that a task was completed, and it is now our turn to work on a task. We use MS Outlook as our email client, and within here I like to use the preview pane. When I receive the Smartsheet notification, I cannot see the task that is ready for me to…
-
Page break / separation between years / header
We have a pipeline report pulling data from a primary sheet that we need to separate out by year. Is there a way to add a row or page break to distinguish and separate the two years? Also, In regards to header row at top of reports is there a way to make the font larger and the width of the column itself larger in just the…
-
Can you deliver a Sight link on a recurring basis?
Created a dashboard for multiple sheets that I would like to send to stakeholders once a week. I don't see any options to send other than publishing a link and emailing myself