-
An Alerts and Actions rule has become invalid
Overnight I've received 20+ "An Alerts and Actions rule has become invalid" emails from smartsheet due to an employee who left our company several weeks back. Although his account was removed via LDAP, his email address exists in smartsheet alerts across our corporate smartsheet account. Is there a way to completely remove…
-
Notification Not Working
Hello! I am trying to setup an alert to notify me right away if the percent complete changes for specific rows in my Smartsheet. I set up an alert to notify me when "a row is updated" and selected the specific rows (Task Name) I need updates for. When I went to test it out by updating the % complete for one of the…
-
Alerts not Sending to Assigned To Column
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share. At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today's…
-
Is there an Automatic Save feature for sheets?
Is there a feature to have sheets automatically save? My group and I have found it very troublesome and inconvenient when we lose valuable work due to the browser closing or changing tabs on active sheets. It's nice that the sheet notifies us that we have not saved, but sometimes that could be overlooked if you're moving…
-
Email reminders not working properly
Hello, I am having issues with the email reminders not working. We use Smartsheet to hold all of our contract due dates. I want to be able to receive an email 30 days before a contract is up. So I created a column that is a date 30 days before the due date, and set a reminder to go out when that date shows up in the…
-
Notify When Task Added
Is there a way to set up a notification for when a task is added and assigned to you?
-
Modified Date and Conditional Formatting/Alerts
I have hit a problem that Smartsheet can't seem to deal with. My goal is to create a sheet that runs conditional formatting based on the differential between 'Modified date' and a TODAY equation. Firstly I tried to create a TODAY based formula in the conditional formatting tool. However, this acted as a figure once…
-
Smartsheet/JIRA Connector: Errors during Sync (Proxy Errors)
Hi there: So we have a number of smartsheets linked to JIRA via the connector and over the past couple of days I've been receiving error emails that say "Invalid response from JIRA. statusCode: 502, reasonPhrase: Proxy Error statusCode: 502, reasonPhrase: Proxy Error" Assuming we need to contact JIRA/Atlassian about this…
-
Approval Requests
Is there a way to send an approval request to multiple people but require only one to approve it? For example, we would like either our AVP or our VP to approve travel requests, but they don't both need to approve. If I include both names in the section, then it adds a column for the second approval, which isn't…
-
Enhancement Request: Sheet/Workspace Level References in Formulas
I would like to create notifications for the creation of new sheets in specific workspaces and in general better track what sheets are getting created where. To this point I would like to build a master sheet with drop downs for each workspace showing what folders and sheets are in them. A directory if you will. This would…
