-
Upcoming Live Virtual Workshops – EMEA and APJ Times!
Join one of our live, interactive workshops for expert insights and real-world applications that will help you uncover how Smartsheet can relieve the common pain-points in your workday – so you can focus on the work you care about most. Open to all, November’s workshops are designed with introductory-level Smartsheet users…
-
Change cell value automation
I am trying to change a task to started if there is time in the duration column. The duration comes from a cross-sheet formula, I know this automation cannot be triggered by a cross-sheet formula so I setup a duration helper column to be the trigger from the same sheet, but it still does not change the cell value. I want…
-
Approval Request - Error Message for Contact in Cell
I am trying to set up an approval automation for my Smartsheet for a contact in a cell. When I try and use the contact column I get the error message "please select at least one column that is not a comment or attachment". Also shown in the image attached. There are attachments and comments on most rows, but this hasn't…
-
Logic for Required Fields on Forms
I have a form that I am working on where I would like this logic: If box is checked, then field is required I spoke with support and they informed me that this is not a currently available feature. What I'm trying to do on my form is have it so if the user checks a box that they want someone to reach out to them, then they…
-
Automation Limits
Hi, has anyone found a way around sending automations that are over 2,000-character limit? We aren't prepared to purchase the additional add ons, we have this process yearly but it's just a notice to send. Anyone have a way, or do you know if I can attach a file using automation?
-
Enhancement Request for Smartsheet Proofing Features
Hello Smartsheet Development Team, We would like to request enhancements to the Smartsheet Proofing features to better facilitate the processing of RFIs and Submittals in the construction industry. Currently, due to limitations and licensing requirements, we have paused using this solution and reverted to manual data entry…
-
Equipment inventory log
I am trying to create a workspace with multiple spreadsheets that will transfer rows back and forth from one to the other automatically. I have a sheet for inventory, one when the equipment is assigned to someone, and another to archive any movement. I have a form that they fill out when assigning the equipment out which…
-
Month over Month Variance w/ live data help.
Hi SS Community, I am trying to create Month over Month varience report for my project management work flow. I currently have a Smart Sheet and Sales Force integration that updates my data live 2 ways, and that's where my problem begins. Below is a screenshot of Project Status dashboard graph as of 10/28/24 . I'd like to…
-
Does sorting not stick?
I have a sheet that is a recipient of a 'Copy Row' automation when criteria on a different sheet is met. In the recipient sheet, we have it sorted in a particular manner but it seems to break all the time and just shuffle the rows around. From what I can tell, it is in no particular order either. We were assuming that the…