-
Are automations shared with other users when the sheet is shared?
Hello, I have set up a Goods In mastersheet which I will be the owner of. Within this I have set up 13/14 automations to notify different users when they receive a parcel. I have then shared this sheet with the Goods In Manager who will be inputting the data onto the sheet, will these automations also be shared with him or…
-
SLA Calculation Strategy
Background: There are four (4) SLA priorities in the Ticketing intake: Critical = 4 hours: High = 8 Hours: Medium = 24 hours: Low = 48 Hours Using the Created Date (including both Date and Time) I need to create the Planned SLA Finish for each ticket. SLA Plan is expressed in Hours This needs to also be a Date and Time…
-
Formula based on last modified date that skips weekends
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
-
Submitting names to a Smartsheet column
Hello everyone. I need some helps with name additions. At my company we are going through a major hiring phase and my reporting lead and myself are getting asked repeatedly if we can add names to a column in one of our Smartsheets. Is there a way I can create a sign up sheet per say where only the supervisors can add the…
-
Is there an automation that can be set up to run a Data Shuttle workflow when a row is added to grid
I am trying to see if there is an automation that would run when a row is added to a grid, it would trigger a particular Data Shuttle to run on. Basic over view is I have created a visitor check in. I have a Data Shuttle (Off Load) run every 15 mins were it takes the names of the visitors and puts it in a attach excel…
-
Including a checkbox column in formula returns "INCORRECT ARGUMENT SET"
Hi all, I am trying to make a formula that Calculates the hours spent on tasks with certain conditions. I have 2 arguments in my formula that are currently causing it to return this output. Here is the formula: =SUMIFS({Custom Engineering Requests: Days To Complete}, {Custom Engineering Requests: Drawing Category},…
-
Add Count Unique function
Please add a COUNTUNIQUE function (or COUNTU for short). It's a pretty self explanatory and similar to other COUNT functions. My intent is to have an automatic Project ID number that is based on the unique project title and I can have multiple entries of the same project title without the ID changing. There is a work…
-
Resubscribe to an automation email?
Hey all, A critical member of our workflow has unsubscribed from his approval emails. After doing some digging on the forums I have found a couple solutions: -Remove his email from the notification list in the workflow, then add him again -Duplicate the workflow Neither of these work. The workflow still says the user has…
-
Inventory Workflow to only include fields with missing items
Hello Smartsheet Gurus! I am attempting to create a workflow that notifies a team about low inventory in an email. There are multiple teams in my org. Each has responsibility for about 20 items. I have the workflow set up to only notify the team of their items status but I can't quite figure out how to notify them only…
-
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…