Automations
Discussion List
-
Can the selections from a dropdown multi-select question in a form be used to auto create columns?In Using SmartsheetIf I have a question in a project intake form that allows for individuals to multi-select all of the rooms that will be a part of a project can I then in turn use those selections to automatically create columns in the worksheet that corre…
-
"Copy Row" Automation workflow creates duplicates in final sheetIn Using SmartsheetI have one sheet where we catalog all the estimates that we do. Each row is an estimate and there's a column that has the contractor for that job. I made a workflow where this sheet copies each row that is marked with a specific contractor…
-
Unable to change cell with using an automationIn Using SmartsheetI am trying to create an automation that changes a cell when another cell changes. For example: When status column field changes to On Hold, the Health column field is to change to the yellow circle (symbols option). It does not give me …Answered - Pending Review 17 views 5 comments 0 points Most recent by David Tutwiler Using Smartsheet
-
Programming with SmartsheetsIn Formulas and FunctionsIs there any way that I can use external programming to effect my Smartsheets. Is there an API that would let me right seperate programs to control my Smartsheets?
-
Changing an auto-generated number in a cellIn Formulas and FunctionsHello, Is there a way to override, or edit, an auto-generated number? I have an intake project sheet that generates "Job #" as new requests come in from a form. Recently a 'new' request was submitted through our form, giving tha…
-
Using forms and multiple rowsIn Using SmartsheetHello, I have created a form for my team to enter data to populate on a master sheet. We will have multiple part#'s and QTY's per request, however, I cannot find a way to have forms split those into separate rows. Is there a way to have a…
-
I need to use an IF / THEN formula to compare a cell from one column to a cell in another columnIn Formulas and FunctionsI could really use some help! Thank you in advance! My STATUS column has the following colored options available per cell: Red, Yellow, Green and Blue. I am looking to use the following IF / THEN statements: 1. In STATUS, if the DELIVERY…
-
Uncheck cell based on values in another sheetIn Formulas and FunctionsHi all, I have a workflow request. I am trying to get a checkbox to reset to unchecked based on a series of conditions in another sheet. The below screenshot is the first sheet in the workflow. In this example, the checkbox in the column…
-
Can I get alert for update request in Microsoft teams? (not as a bot, but as in team's chat)In Apps, Integrations, and Add OnsHi All I am trying to send an update request via microsoft teams and I successfully set up a workflow. But, the problem is the link to update the request is only coming from a bot of smartsheet rather than into the team(group) created. Und…Accepted Answer 35 views 4 comments 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons
-
Process flow that also includes daily task checklistsIn Using SmartsheetI am new to SmartSheet. I've developed a comprehensive process flow for our recruiting process. It has the tasks to be done, start/completion dates, who they are assigned to, and other steps. But there is one thing I can't figure out. Wi…
