Automations
Discussion List
-
When move/copying rows, how to prevent new columns being added in the destination sheet.In Formulas and FunctionsIn Smartsheet's article, it's stated that "If the source sheet contains columns that the destination sheet does not, these columns will be created in the destination sheet when the row is moved or copied." Is there anyway to prev…Answered - Pending Review 27 views 5 comments 0 points Most recent by Maram Mohamed Formulas and Functions
-
No options for selection of destination sheet to copy rows with automationIn Formulas and FunctionsTrying to copy rows across sheets across workspaces (both of which I own) but when I go to select destination sheet nothing show up, blank screen. Any thoughts on what I may be missing here? Thanks in advanceAnswered - Pending Review 17 views 3 comments 0 points Most recent by Maram Mohamed Formulas and Functions
-
Approval workflowIn Using SmartsheetHello! I need to create an approval workflow with these conditions. Please also find below the problems I'm encountering: When a row is added, changed, or deleted. (Problem #1: I don't manage to set this up for rows that have been deleted.…
-
"When Triggered" Automations BehaviourIn Using SmartsheetA colleague of mine has sent me a question that has stumped me and has got me thinking my understanding of how automations work has been wrong. She sent me the following: We have automations that are set up to send when triggered that sen…
-
I need help and suggestions for creating following sheets:In Using SmartsheetHello Community, We would like to create sheets, which will be working for the following functions and trigger the right authority on time: 1. Perform monthly vendor scorecards 2.Have an approved vendor commodity matrix that can be share…
-
Automating Cell LinkIn Using SmartsheetI've created a workflow to handle project requests that come in to our department. We have a master sheet where all new requests are entered (either manually or from a webform) then each of our 3 team members have an individual sheet. When…Answered - Pending Review 146 views 7 comments 0 points Most recent by Andrée Starå Using Smartsheet
-
Automating Document Generation and PrintIn Using SmartsheetWe would like to automate the following: "When a row is added, generate a specific document, and print to a specific printer". The idea is that the visitor to the office fills in a form with their details and then those details a…
-
Using Calendar App and JIRA Connector to build a Release CalendarIn Apps, Integrations, and Add OnsI am using the Calendar App to create a release calendar that tracks all our releases along with their respective critical path milestones. I would like to dynamically include the Jira Epics and stories that correspond to each release usi…Answered - Pending Review 39 views 5 comments 0 points Most recent by Maria Gonzalez Apps, Integrations, and Add Ons
-
Lock Cell until conditions are metIn Using SmartsheetHello, I have a checkbox column called Ready for Production which notifies the relevant persons when an item is checked and ready, I would like to lock or leave cells on this column empty until a number of conditions are met, the condition…
-
Row ID (ignoring blank cells)In Formulas and FunctionsI am trying to create a sheet which identifies batches of 25 rows and creates a specific batch ID, before moving onto the next 25 rows. (Batch Column) I also need to formula to ignore rows with blanks entries. (Row ID) I hope somebody is…
