-
Approval Request - Error Message for Contact in Cell
I am trying to set up an approval automation for my Smartsheet for a contact in a cell. When I try and use the contact column I get the error message "please select at least one column that is not a comment or attachment". Also shown in the image attached. There are attachments and comments on most rows, but this hasn't…
-
Automation not displaying sheet I'd like to move rows to
I've had this issue before and still continue to have this issue where a sheet that I create (for archive purposes) is not displaying in the automations for me to move rows to. I created this sheet last Friday and it's Monday now, and the sheet is not displaying. Does anyone know why this is? This isn't the first time this…
-
Bridge and ServiceNow for new row
I am clearly missing something… Overall simple workflow New row in Smartsheet is added —> create a record in ServiceNow. I can get it all to work just as I want it if I define the row. However, I don't know how to define a row that doesn't exist, yet. Any help with this would be greatly appreciated.
-
Parent Child Relation in Dynamic View
I was wondering if there was a way to display the parent child hierarchy the same way it is shown on the main sheet with just the data on the dynamic view of the sheet? I have a dynamic view where all completed and cancelled status projects show up, and would like them parent/child to be displayed as it is on the main…
-
JIra-Smartsheet Connector
Hello All Just trying to figure out it if it is possible to create a Smart sheet workflow from Jira Cloud to smart sheet and within the workflow only connect it to a single ticket or Epic. We do not want it to pull the data in from the entire project. It is a Jira Work Management. Trying to figure out if there is an option…
-
Can I establish a form workflow that builds on each other for the same request?
Hi all, I'm looking to establish a 3-part workflow that will have 3 forms that will build off the initial request. Here's my scenario/steps: Step #1: User A submits an intake form. Step #2: Once that intake form is submitted, it triggers an alert/workflow to Owner A (owner of this process) to complete another form that…
-
Workflow for After Hours Tickets
Hi all, I currently manage our support tickets smartsheet and live on east coast. I have a team member who lives on West Coast and I want to create a workflow to have any tickets submitted between the hours of 5pm EST and 8PM EST sent to him with a notification. Currently, I am capturing the date/time ticket is submitted…
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
Needing Two Timestamps in One Smartsheet
Hello, Can someone please assist with having two timestamps? I need to have our "Timestamp" in the first column when the customer submits a quote request, and another timestamp in "Arista Timestamp" (with date and time) of when "Quote Request Sent To WWT?" changes to "Yes". Right now my workaround is to have it record a…
-
Is it possible to pull data from rm.smartsheet.com to smartsheet.com automatically?
Hi, We're trying to automate reporting, to prevent having to manually download data from rm.smartsheet.com and edit in different programmes e.g. googlesheets. Is it possible to automatically pull data from rm.smartsheet.com into smartsheet.com, which then feeds into a project dashboard in smartsheet.com? The only benefits…