-
Automation deactivation issue
Hi Smartsheet experts, I have a recurring issue with an automation deactivating itself, and I cannot for the life of me figure out what the problem is. The trigger "Status" column is manually adjusted - it is not connected to any other automation. Can anyone see an issue here that I'm missing?
-
Issues with Attachments
Ok, I'm not new to Smartsheet but recently this simple automation has had me stumped. Pictured below is a simple automation we use to verify that an attachment has been added to each row in our system. IF attachment added or changed, THEN Change Cell Value. These worked beautifully all over our system until about a month…
-
Automate when cell has contact added to remove all Pending Update Request for that row
When a form is filled out, and a row is added to my sheet, I have automation send to 3 recipients to update the "Owner" field. I want that Update Request to clear for all users and the whole row when an Owner/Contact has been added either through the button it sends/updates with or if anyone goes in and updates the…
-
Record a date automation isn't working
I set up the automation below, and it's not working. When I change the status of a row to complete, nothing happens. If I go into the automation manager and select "run" or "test" the completion date column fills in with today's date. What am I doing wrong? This should be straight-forward. I've tried building this…
-
Use Emails in Text/Number field in an Automation?
On a form, I have a field set to "Text/Number" as the "Field Type" with "Validation" → "Email" selected for that field. However, it seems I cannot then create an Automation that picks up that field/column as the contact for an automated workflow. Am I doing something wrong? If not, is there any work around to this?
-
Integration Smartsheets >HubDB
I'd like to integrate a smartsheet that pushes data into a HubDB in hubspot. Is this possible? How did you make the connection?
-
Trigger suggestions for blank updates request
Hi everyone, I have seen a handful of articles on this topic, but sadly none have made sense to me. I have a process where a student submits a form, which through automation is in turn sent to an employer using the "Request Update" feature. The employer is supposed to review the content and then complete a series of…
-
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…
-
Merged: Copy an automation from one sheet to another
This discussion has been merged.
-
Sheet Automation Workflow: Can you set a Run workflow cadence to Bi-Weekly or Monthly?
Is it possible to have a workflow run Bi weekly, Monthly, etc? Only options I see are "When Triggered", "Hourly", "Daily", and "Weekly". Thanks for the support if any functionality exists already. If not a function. SMARTSHEET can you make this a reality?