-
Perpetual Contract Renewal Formula
Hello All! I am trying to create a formula that will automatically update the end date to a contract based on a renewal timeframe. For example, Contract Start date 12.31.19, Contract end date 12.31.20 at the end of the contract, the contract will renew for 1 year perpetually on the same date. Right now we are at 11.8.24,…
-
Allow User to Expand the Text Box for Customize Messages in Automations
Please add the ability to expand the text box when writing text for a customized message that is part of an automation. In most software, this means an option to click on the bottom right corner of the box and drag it out to expand it. It is helpful to see the entire message when drafting it, and later when reviewing or…
-
Reduce Lag Time for Automation Triggering
The lag time to trigger Smartsheet Automations is extremely variable and often far too long (usually 1-2 minutes, but Smartsheet claims could take up to 15!). This is a frequent complaint from my users and significantly limits the utility of these features. I frequently need to use a copy or move row automation as the…
-
Automation Error Message
I have an automation set up send alerts to specific email address input in a column. My settings are set to unrestricted and 11 of the emails sent successfully. I got an email letting me know 'some recipients aren't receiving alerts…' and that this impacted 17 cases. When I tried running the automation row by row for 6 of…
-
Formula or Automation Help
Im looking for the best way to set up this formula/automation (whichever is best): I have multiple columns collecting different contact names by title from a form: I need a formula or automation, that when "Admin Reviewer" = yes, then it takes the contact in "Project Admin" and adds it to another column titled "PT Proof…
-
Automation Help: Regarding Proofs
I want to record a date, when certain people approve a proof. When I set up a proof I am inviting several people, however, I need to record a date when a specific person (technically it could be 1 of 3 people) actually approves the proof. I have the {Proof Approved By} column (and as everyone approves their names appear in…
-
Automation Workflow Triggers - Delayed response
I'm not sure if this is normal, but I have a simple automation to update a cell value when another cell value is changed. The trigger is working and the update works, but there is a significant delay in the response time. Over a minute from the time I make the change until the automatic update is performed on the sheet.…
-
Bulk Action on Workflows
It would be nice to be able to take an action on all, or multiple, workflows at the same time. If you have a sheet with 20+ workflows tied to it and you have a need to deactivate the workflows (data migration), it can be a pain to deactivate each workflow and then activate them all.
-
Room for Automation Notes
Add a notes field that would appear in the automation summary for people to put process notes for others to understand process.
-
Formula columns not updating automatically after data is pulled in via datamesh
We discovered that our formula columns are not updating automatically after data is pulled in via datamesh and they only update if someone goes into the sheet, clicks into some cells, then saves the sheet. Support told me to set up an automation on the sheet that does something like locking then unlocking a specific cell…