-
Automation fail, and sheet repopulates old data
I am trying to move a line from one sheet to another. I create the automation, run it and test it and it works fine. I submit a request, click acknowledge, and it moves it to the desired sheet. Then I get an email that says the automation is broken and about 50 lines auto populates old data back onto the sheet I am…
-
Auto-Sorting sheet hacks
Hey guys! I've long been searching for a way to make one specific sheet auto-sort, without having to create individual reports. I know this has been a requested feature for ages and that it's in the works. I was curious if anyone has come up with any clever workarounds that can be used while we're all anxiously waiting? I…
-
Group Rows Automation based on unique column ID
I am looking if there is a way to group rows that share a unique cell (i.e. Quote #) into one parent dropdown. I am wondering as a workaround due to the fact that the "Copy a row" automation from one sheet to another does not update the existing row but rather adds another row for the same quote ID # in this case. We are…
-
Pls Help! Automating Rollover of dates Based on change of a status
Hi Everyone, Can't seem to find much information on this topic can anyone help with the below? Or point me in the right direction. Trying to create an annual calendar with deadlines. The calendar includes Monthly, Quarterly & Annual Deadlines. The idea is that when a team member changes the Tracker column to "Completed":…
-
Approval workflow - Declined - Request Update -> how to send back for approval?
When you have a workflow that is declined I have request update selected but struggling to figure out how to send back into the workflow approval.
-
Notifying someone they were assigned multiple new tasks without sending a notification for each Task
I have a task tracker sheet and regularly enter multiple tasks that are assigned to a single person. What is the best way for me to notify them of the new tasks without having a new notification sent for each individual task? Thanks in advance.
-
Merged: Enhancement Proposal: Business Days in Smartsheet Automation Conditions
This discussion has been merged.
-
Send to Teams Chats as well as Channels
I would love if we could connect workflow notifications to group chats on teams instead of just teams channels. For our company, we use the chats much more than the teams channels.
-
ServiceNow and Smartsheet BRIDGE integration
Hi, I am trying to bring all records from a table in ServiceNow into my Smartsheet. All field names align and I am able to get the record from ServiceNow but unable to send that data into an existing Smartsheet. I did get it to add one row from ServiceNow but that's only if I reference the row specifically in the Key and…
-
Changing display name causing dups?
We have a custom built Smartsheet solution. When it was built the person's full name was used in various places in the solution, used in formula's and automations. What we have discovered now that we are using the solution, is when a person goes in and updates their display name in their settings, from Robert to Bob or…