-
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…
-
Remove "automation@app.smartsheet.com" from sender email address
The OIT Security department at my university received a report that an email from automation@app.smartsheet.com may be phishing. We send a number of Update Requests through Smartsheet that require action from the receiving party. If the email is perceived as phishing by the recipient (or flagged as Spam by the email…
-
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…
-
Reminder automation
Hi! I'm trying to set up an automation for weekly reminders if certain conditions are met / not met, and from what I can tell everything has been entered correctly, yet when I run it to test it seems to fail. Any help is appreciated! Here's a description of the situation and what I have set up: Several farmers markets have…
