-
Why do my automation rules take 1-3 minutes to update when trigger is "when triggered"
I have been trying to create several automations that simply update a field based on the data in another field. Example is when Status = Complete, update % Complete to 100%. OR When status = Complete update a comment in the comments field. No matter what rule I create, it takes upwards of 3 minutes for the changed cell to…
-
Using INDEX/MATCH with images
Hi all, Is it possible to use an INDEX/MATCH formula to bring an image from one sheet into another? If not, anyone recommend a solution/ work around? I am building a new sheet that utilizes INDEX/MATCH to bring in info from several others and I would like to be able to bring in these images from their source document.…
-
Populating a Smartsheet from an Oracle SQL DB
We use a smartsheet to track the progress of investigations on my site. The investigation ID, description, etc. are stored on an Oracle SQL DB and I'd like to autopopulate the smartsheet with the relevant fields. Is there a way to do this? I tried Power Automate but my organization does not currently support the Smartsheet…
-
Pull cell value based on matching value in two sheets
Hello all, hoping someone can help me with this question. I need to pull a cell value into Sheet 2 based on a shared cell value in Sheets 1 and 2. Specifically, I need to pull the value from the MIN Score column in Sheet 1 to the row with a matching COSMOID in Sheet 2. For example, Client A has COSMO ID 123456 and a MIN…
-
workflow automation - rows aren't moving?
Hello, I created a workflow to move rows once a column status is changed to "complete" within any row. But the workflow didn't trigger, even when I manually changed the status to something else and back again, saved, refreshed, tried again. It finally worked when I moved the row to a different spot in the sheet (shifted up…
-
Daily Automated Workflow when a row is changed - each instance or a final state?
If I choose a daily workflow alert to a person when a row is changed, and the row changes 3 times in the day - all in the same cell (like the date due), will the recipient get each change in the daily email or just the last recorded change?
-
Why isn't the workflow triggering and moving the data to another sheet?
Hi, I have the following workflow set up where the data needs to move to the delivered sheet once the date is in the past. For some reason, the workflow is not working. Both sheets have the exact same column headings. Can someone review and let me know what's missing?
-
Unsusbcribe From Notifications
Hey Community, Any way to resubscribe to an alert workflow? The system won't let me add back a user that has accidently unsubscribed. Thank you!
-
Can you re-trigger an approval workflow?
I have a couple different scenarios that I've run into. The first is that the end user is saying that the approval request isn't coming to them, so they can't approve anything. The second scenario is that the approval goes to a person that they wrongly identified and we need to re-route the approval to the appropriate…
-
Smartsheet workflow copies row before all columns are stored by an AppSheet app
Hi all, I have an AppSheet app which saves its data including two pictures into a smartsheet sheet. This smartsheet sheet has a workflow which copies the each new row to another table. Sometimes the row is copied before all pictures are saved. I don't know why. Does anybody has an idea how to fix this problem? Thank you,…