-
Copy & Paste Contact Cells between Sheets
Currently only able to copy and paste contact cells on a single sheet.
-
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…
-
Automation: When there is a change and the field already has a vaule
Looking to send a notificaiton if a date field changes, but not if it was already blank before the change. Basically I want to send a notification when the date changes, but not when the date is first assigned. Anyone know how to do this?
-
Removing Total Row from Smartsheet Reports
I am creating several reports that subtotal financial information by various groups (i.e. revenue, numerous expense categories, EBIT etc.). I do not want the reports to display a total row that sums all the revenue, expenses, and profit as this is misleading. Does the functionality exist to turn this off?
-
Record of workflow alerts
Smartsheet doesn't have a way to see if the email was sent, to whom the email was sent and what was the email that has been sent. We can only see when the workflow last run and work on blind faith that it actually was successful. Only to find out weeks later people aren't receiving the alerts, and there isn't a reason why…
-
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…
-
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…