Is there a way to create an Automation that when some criteria is satisfied (like status is In progress) and I update one field with the data from another field in the same row? let me explain, I want to automate the % Completion bar progress with the actual % based on the time consuming at today's date. So every day, or…
When creating an automation workflow from scratch, where we request an update, is there any way we can make the fields that they have to fill out required? What we noticed when we did this was that multiple people were not completing all the information we needed them to, so when we would see what was updated in the…
Hi All! I wrote a Python script that will run an update to make changes when a form submission is added. Works great, however I have to manually run the script. I know you can use a scheduler to run, but I need the automation to trigger when form is submitted. I do not have a server and from what I have read, Flask and…
What is the easiest way to take files attached to each row in a Smartsheet and save those files out to a sharepoint folder? I know you can download them all and then go to SP and attach them, but surely there exists an automated way to move the files without ever personally touching them. Bonus if I can do it when a…
It seems incredibly bizarre that automations cannot be copied across sheets - this is a huge pain at the enterprise level where permissions are sectioned by sheet ((i.e. Markets) but automations are needed for the global team. Creating every automation is a massive issue.
Hello All, How can we fix this error? The only change that was made was to the destination sheet and it was to change the owner from one person to another. Would that have anything to do with it? Here is the error in my workflow: Thanks! Ryan Holguin
I have set up to sent the notification once the task is assigned to a person. That notification should include the key information's columns and also attachments. It used to see the PDF icon in the email coming through but it is no longer there. Once you click the link to open the form, I can still access to it, but there…
We use control center to provision new projects. Our work plan template has a predefined project schedule using dependencies. Row 22 (after the navigation and summary rows) is "Manager set schedule", and is automatically assigned to the manager from the project intake sheet. The intent is for the manager to adjust the…
It would be super helpful to have the ability to create an automation/workflow from a report so that my team can get ONE comprehensive email/alert each week for a "request for updates" across all sheets that are being pulled into the report. It can be daunting for a user to receive a similar alert via an automation or…