Automations
Discussion List
-
Webhooks occasionally stop working - has anyone else experienced this? Any workaround ideas?
We have been using webhooks to extract, from contact column types data, the raw email (needed for addressing other needs within a build, including cross-sheet formulas, automations, etc.). However, we do see that sometimes this will fail, or stop working without any warning. Does anyone have any ideas on possible…
-
Interesting Uses for Smartsheet's AI
Hello all, My company has been looking for an agentic solution to Smartsheet for a long time so I'm super excited about this update. I would love to learn about any things you have all discovered with the AI. One thing I've been using it for figuring out if we have overlapping milestones across projects. It's so nice not…
-
Contact List fields
I'm working on a project where I want to reference the contact list field in an automation email body, but it only pulls the Name field of the contact list item. Is there a way to get just the email address or does anyone have a good workaround for this?
-
Login help (which is not in the right discussion, but there were no correct choices!)
I do not have access to my account. After "too many attempts" it locked me out, but it had been over 12 hours since my last attempt. I cannot use the reset email because my company has been bought since we first acquired an account and that email no longer receives messages. WHAT AM I TO DO?
-
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…
-
Deciding over which one to use
When do you choose MCP over a Zapier automation or a direct API call? Where's the line for deciding?
-
Tracking what a Delay is within a Project
This may be a longshot, but I am wondering if there is an easy way to track what a delay is within a project? My best thought would be to make it a manual field within sheet summary that is a dropdown. It would be called something like Project Delay with dropdown selections like: Customer, Supply Chain, Sourcing, etc. Not…
-
How to troubleshoot workflows randomly firing?
Yesterday it was brought to my attention that on 9/2, a bunch of rows in a sheet I manage had randomly been updated. The Activity Log isn't very helpful to troubleshoot, but it appeared based on spot checking that it had impacted rows that were 'closed requests' so I added a condition to all my workflow rules to NOT change…
-
Update value in cell with value from another cell within the context of automation action 'change value in cell'
@Paul Newcome I have 2 worksheets; Master List of site locations Tracker This worksheet pulls in some data from the Master List, i.e., site name, site address, site contact, etc. using and INDEX/MATCH with the 'Site #' as the unique identifier When the Site Address updates I want an alert to 'send to everyone shared to…
-
Alert Running before completion of Update Request
I'm currently running into an issue I haven't come across before where alerts underneath an update request are running before the update request is completed. It has always been a function of the automations before last week where an alert would only run after an update request was complete and fulfilled. This has impacted…