-
Unable to input external data to SmartSheet through API
Hi community members, I'm working on a project to fetch our students' quiz score data from Blackboard, an education platform, and send it to Smartsheet using the API. I've successfully retrieved the data from Blackboard and prepared it for transfer to Smartsheet, ensuring the data is correct and the column IDs match those…
-
workflow automation - copy row without including attachments
Does anyone know if there is a way I can adjust my automated workflow so attachment are not included when copied to the next sheet? Currently my workflow is set so when a status is changed it copies to 2 other sheets for the next applicable departments, however they do not need (and in some cases maybe shouldn't have) the…
-
Trigger (Automate) an update request to go to a Slack Message
Our team uses Slack, and it would be great if we could trigger an update request that goes to one of our Slack channels. A link or button that is sent in a slack message to the channel that allows a user to fire the update request (similar to the email version) but without the "email" part would be PHENOMENAL.
-
Why doesn't automation work when I use "Send from organization" option?
I have set up a workflow to Alert Someone when triggered. When I change the sender option to "Send from organization" I see my organization name. However, when I test it, I no longer receive a message (workflow doesn't run). If I change it back to "Send from Smartsheet automation" and test it again, it works just fine. The…
-
Single source of truth from two sheets of shared data
I've been tasked with creating a workflow or function that lets Company 1 add rows (sales leads) containing simple client / salesperson data, and status of the lead. Company 2 would then access a sheet with this same client data, but only be required to change some drop-downs / text related to status. I started with two…
-
Move Rows Automation Suddenly Failing - Multiple Sheets
Hi. I manage 3 very similar smartsheet tools for 3 different office's training request intake and approval systems. Once requests are approved, an automation has successfully been moving them to each site's Request Archive Sheet. This has worked as expected since March. For some reason today this feature has suddenly and…
-
Collect a date when row is taken off hold
Hello, I'm looking for a method through automations to collect a date when the status changes from On Hold to anything else. I tried the screenshot below but I'm not getting the intended result. I have another automation collecting a date when the row gets put on hold as well. Any suggestions are appreacited!
-
Automated emails not sending attachments
I am having trouble with Smartsheets not sending not sending attachments. I have it currently set up where I have to approve it before the email gets sent out. Once I approve it I have a separate automation send an email to group 1 or group 2 based on which option they pick in the form. At first I was having trouble with…
-
Cannot find sheet for copy automation
I have three sheets that I am trying to get to copy to each other for bidding. I have made this automation for multiple other projects in the past. When I go to find the sheet that I am trying to copy to, it is saying no results found. I am an admin on all sheets that I am trying to use. I have copied and pasted the entire…
-
Setting automations based on time in a cell
Automations can be set to run on a date found in a cell. Automations are able to be set to run at a particular time. Is there a way to have the automation look at the time in a cell just like with dates? This is so important as certain alerts are not only date sensitive but also time-sensitive.