-
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…
-
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?
-
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
-
Update Requests included in separate Notification Automation
Hi! We have a sheet where team members are triggered to complete an Update Request when a line is assigned to them, which of course includes its own messaging. We also have a separate automation which sends out a weekly 'reminder' email for all assigned lines which have not been updated to a 'completed' status. My question…
-
What’s Your Elevator Pitch for Smartsheet? 🚀
Hi Smartsheet Community! I’m curious—how do you sell the value of Smartsheet in 30 seconds or less? We all know Smartsheet can transform workflows, improve collaboration, and make life easier—but when you’re trying to gain buy-in from leadership or teammates, what’s your go-to elevator pitch? Here’s the challenge: Keep it…
-
Post Dashboard Demo Questions
I always get the same question after I do a dashboard demonstration. 😂 "How do I export this to Excel?" What are some questions you get after demonstrating a Smartsheet dashboard's capabilities?