-
Linked Sheets/Copied Rows
I created an automation that copies a row from one sheet to another based on certain conditions. What I am curious about is if there is a way to have information flow back to the originating sheet if changes are made in the 'linked to' sheet. Currently, I can only get the row information to flow one way and I'd like it to…
-
Free Smartsheet Webinar Series by DigitalRadius
I wanted to share an exciting resource that I think a lot of you will find valuable! Our Customer Success team here at DigitalRadius is hosting a Free Smartsheet Webinar Series now through the end of the year, designed to help you unlock the full potential of the Smartsheet platform. It starts tomorrow! Here’s what’s…
-
V Lookup formula for importing Contact List broke and I don't know why.
So I have a reference sheet of contacts and their assignments. I made a different sheet to assign tasks as they come in and set up an equation to look up and auto assign. It looks like: =VLOOKUP([Rule Number]@row, {Committee Range}, 2, false) So when a task came in and it matched the rule, it would assign the person in the…
-
When a date reached Trigger, not running
Hi All, I'm hoping someone may have experienced this previously & may be able to help, I have set up a 'when a date is reached trigger' that runs every 3 months for update requests for our team in Vic, I have recently recreated this to also run for one of our teams in Qld, very same automations with just a different start…
-
Merged: Bulk Action on Workflows
This discussion has been merged.
-
Is it possible to automate a work flow that sorts rows by date when a sheet changes?
I have a sheet that I pull reports from into a dashboard. it would be great if the most recent rows sat at the top of the sheet. Currently I have to manually sort the date column.
-
Merged: Message Includes: All Non-Blank Fields
This discussion has been merged.
-
Generate document-Multi lines of Text issue
I am attempting to generate a document with one area using multi lines of text I put into a cell through using ALT+ENTER. However when I generate the document for these fields they do not generate vertically as mutli lines and keep scrolling as run on text. I have it set in these form fields in Adobe as Multi-Line and…
-
Automate Attachment Delivery
I need to automate the delivery of an attachment (using the document generator feature) to a contact list once a row is marked done. The contact I need to send to is not a Smartsheet registered user. Is there a way to send the attachment without using the sheet link?
-
Automation - While copying/Moving Source Sheet to Target Sheet, how to update columns in Target shee
I have following questions related to workflow automation Is it possible, based on certain conditions in Sheet-A copy Sheet-A to Sheet-B and manipulate another column in Sheet-B (This Column is not in Sheet-A) through a function? Based on certain conditions in Sheet-A, will it be possible to delete a row in Sheet-B?