-
Hidden or outdated automation?
Hi there… So my supervisor is getting an email for a certain automation that has been updated and no longer has the message that she is receiving: "Please update my online sheet." No automation in this sheet has that message. Is it possible Smartsheet is working off of an outdated automation, or one that isn't being shown…
-
Help with cross-sheet automation and formulas
I have 2 separate sheets to manage my team's assignments. One is a weekly assignments sheet that pulls from a partner request form and a daily assignment sheet where I manually assign tasks and priority level to each assignment. I want to make it so that when I assign Tier 1 or Tier 2 priority on the 2nd sheet, it…
-
Multiple Due Dates and Reminders
How do i create automation to run on multiple dates in a row?
-
Is it possible to automate delivery of a form when a user adds a specific type of row to a sheet?
We have a list of "tactics" (dropdown list, single selection) and if one particular tactic is chosen, a workflow is set up to notify five users so they can prepare for required work on their end. Let's call the tactic "launch". There are additional pieces of information required once a launch is scheduled, and I am…
-
Copy & Paste Contact Cells between Sheets
Currently only able to copy and paste contact cells on a single sheet.
-
Trying to increment a value by 1 each day, based on a specific status. - GOV
Each day that a row is in an 'In Progress" status, I want to increment a counter to determine the # of days in progress. So far I have tried an automation that runs daily and filters based on the condition. But I am not finding a way to add 1 to the counter. I have thought about doing a function but can't find a suitable…
-
Bridge examples including Javascript
Hi fellow Smartsheeters! In preparation for my session at Engage 2024, The future of workflows, I'm posting a variety of live Bridge examples to this thread. Each "block" will have a use case description, workflow layout, and (if needed) the javascript code I used. Enjoy!
-
Form not auto populating fields if one column cell contains a comma
I'm using a form that when triggered, populates several fields from a source sheet then posts to a another sheet. I've noticed that if the column titled "Description" has a comma in the text of a cell, such as image 1 below, then the form will not auto populate all of the fields that I want. It will also stop populating…
-
The smartsheet to copy rows to when setting up automation doesn't show up in search
I'm trying to set up an automation to copy rows of a smartsheet into another one with only one trigger and condition. I get to the end to select a smartsheet to copy the rows to and the smartsheet will not come up in the search. I'm set up as admin for both sheets and the new smartsheet I'm copying to was set up last week…
-
Adding Attachments to a specific row via Email
I am wondering if there is a way to send an email that would be connected to a specific sheet and a specific row for file attachments. I know other PM systems will allow you to send an email to a specific project and task that will add the attachments to that specific project or task. Is this possible? If so, how does one…