-
Automation disregards conditional logic and copies every row
Greetings Smartsheet Wizards… I have created an automation that is supposed to only copy rows if a particular column is blank. The conditional block is set to "where column name is blank". However, the automation copies every row in the sheet, even the rows that contain text. Does the is blank condition not work correctly…
-
Automation to add links in a column in origin sheet from destination sheet.
Hi, I set up an automation to copy a row from someone's intake sheet when they assigned it to my team into my intake sheet. We did this so we didn't miss any of the metadata they are capturing. Can I set up an automation that copies a column that has "DAM Link(s)" from my intake sheet back into the original intake sheet…
-
Automation email row limit issue
We are using Smartsheet for a sign up process with forms and automations. However, automation emails seem to have a limit of 20 rows per email. We need assistance in finding a way to increase this limit or explore alternative solutions.
-
How to automate data involving dates and sum totals
I have been researching this topic for some time now and have been having trouble finding an answer - hoping the Smartsheet hivemind can help! OBJECTIVE: To obtain a sum total of data submitted via a Smartsheet form, based on submission date. CONTEXT: I work for a transportation company, and we use a Smartsheet form to…
-
Prevent an automation if a cell is blank
Hi, how can I prevent to trigger if I have a blank cell in a specific column and inform the user that the automation did not work because the cell should not be blank ? Thanks in advance Fodil
-
Automation template not working
I am trying to use the automation template in a work plan sheet, where when I change the project status column to "completed" the "% completed" changes to 100% on the row. I have even tried to reverse it, and say when % completed = 100% change project status to Completed. This seems like a very simple ask, and is a baked…
-
Notification Automations - Links in messaging
When creating a notification automation that includes a url directing a receiver to a report, dashboard etc., sometimes the url that I copy and paste into the message us not clickable, and the receiver has to copy and paste. Is there a step that I am missing to make is a clickable link?
-
Getting the Triggered by at least 5 other workflows but nothing is daisy chained
Hello, I'm seeing this error for the first time as I expand some capability in an existing workflow. Here's how this section with the error works. Scenario: a user puts in a request on the form with a check box indicating they will later upload the required file attachment. Automation sends a request for Approval with…
-
Child row and Multi- contact cell selections
I am currently developing a portfolio management system in Smartsheet to centralize our work. To accommodate multiple project owners, we are utilizing a multi-select contact cell. When a user is assigned as an "owner," the initiative appears on their individual summary sheet. However, we have encountered a challenge: in…
-
Smart Sheet & Resource Management - Functionality
I'm wondering if a) Smartsheet is working on the issue and b) if anyone has a workaround. I'd like to see the status of a task, as it's marked is RM connected to a column in Smart Sheet