Smartsheet Automation not triggering/takes forever to trigger

Jess Bowles

Hello,

We use smartsheets to keep track of and automate our Inventory Adjustment Process. When an adjustment is complete it is supposed to send confirmation to the person who handled the request, but this is often not happening for hours after they complete the row, and occasionally doesn't happen at all!

I have attached images of the automation and sheet rows that are not updating.

Essentially, when the row changes and is marked complete, and [Date sent to handler] is not blank, send confirmation to handler and mark a date in the [handler received confirmation] field.

This is not the only sheet that has struggled to complete automation, can anyone explain why?

This is the automation that is supposed to date the "date adjustment complete" field. As you can see it has not run but there is no reason why.

Andrée Starå

Hi @Jess Bowles

I hope you're well and safe!

To add to Mike's excellent advice/answer.

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!

Mike TV

@Jess Bowles

Sometimes automations and formulas on sheets are either very slow to work or don't work at all because nobody has the sheet open for it to be "active". One way around this is to set up an automation to run on a timed basis so it's running frequently keeping the sheet refreshed. This shouldn't be an issue with the software they use, but unfortunately it is. It seems like something that they should fix asap so that people's sheets are always working as correctly setup but for some reason this isn't a priority. It's been this way for forever I think.

Andrée Starå

Hi @Jess Bowles

I hope you're well and safe!

To add to Mike's excellent advice/answer.

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!