-
Alerting Contacts in a cell
Hello, We have a sheet that we use as an IT ticketing sheet and Form. I setup an automation so that whenever a comment or attachment is added to a row it will notify (email) whoever the assigned technician on that ticket is. This works great when the end users comment, however, when the IT technician makes a reply or a new…
-
Upcoming changes to our automated notifications - live today 17th April 2020
Today the proposed changes to automated update requests / notification has now got the OWNER's name in the email. This is causing us absolute chaos. Update requests have been sent out and as they now have the owner’s name (in our case this morning Kirsten Cox) the owner is now receiving lots of emails from people asking…
-
Automation - Trigger when date and time reached - change time to 15 min increment
When building automations, the handiest way to test is to set the automation to trigger when a date/time are reached. However, only having the option to set for the hour (6:00, 7:00, 8:00, etc), means that after testing, and discovering a tweak needs to be made, one must wait until the next hour to test again. This results…
-
Merged: Workflows Trigger Timing: Date-Time Customization
This discussion has been merged.
-
Conditional Repeating Routines
Hello SS Community: I'm a big fan of automation and something that would help a lot would be the possibility of conditional repeating routines (IF-THEN-ELSE) and using formulas using data from the worksheet, as part of an automation. This would allow sequential tasks to be performed, such as creating a certain number of…
-
What formula to use to add $ and comma in the field
I have a "run-rate" field that sums up values from 4 other cells. What formula can I add so the summed value automatically has the $ sign and comma between the numbers? Also, can I use the same formula in the other 4 cells so that people don't have to add $ and comma when inputting data? Thank you
-
Recurring Cleaning Schedule Setup
I'm helping my Laboratory Department setup a Tracker for a Cleaning Schedule that has a variety of pieces of equipment that each have a different time range of when they need to be cleaned (from every 2 weeks to 6 months). I had it in my head that I could use Gannt functions to setup the varying Durations of each piece…
-
Adding email list for Automations
Hi All, I have a Drawings Sheet that I use to update contractors with up to date drawings, I send them a simple published URL but do not share the sheet with them. (See below) I use another Project Sheet to run the project and keep a status of the jobs. In this lists all the contractors with a Purchase Order for the works…
-
Backend Process for creating Workspace and Project Folder
Hello, Currently we create a new workspace for each projects even if that project has different Location, (ex. X Los Angeles, X New York, X Vegas) will have separate workspace. However, we want to create a one workspace for the same Project and have folder inside that for different location. So X will be the Workspace Name…
-
Why do the automated emails show from "my name" via Smartsheet"?
All forms, sheets, automated workflows, etc. show from "Amber Lange via Smartsheet". Is there a way to change this?