Automation - 'change a cell' not operating until I close & reopen the grid.

Connor Griffiths

I am using a series of automation workflows to change the contents of a cell based on the contents of another. Whilst trialling these workflows, I have to save, close and reopen the sheet for the intended cell to actually update. I would prefer this to be instantaneous. Is there a known solution to this?

Thank you.

Andrée Starå

Hi @Connor Griffiths

I hope you're well and safe!

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

Would that work/help?

I hope that helps!

Be safe and have a fantastic 4th of July weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Connor Griffiths

I hope you're well and safe!

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

Would that work/help?

I hope that helps!

Be safe and have a fantastic 4th of July weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Connor Griffiths

Thanks for replying @Andrée Starå .

I have used this solution previously to automatically update a Dashboard each day.

I don't believe this is the same issue? The trigger is not date-based, it's when I change a cell value. I would expect the automation to trigger whilst I'm in the grid, why do things only happen when I close/reopen anything?

Connor Griffiths

I have noticed that it works with a slight delay which I can fully manage. I will accept the answer above.

Thanks for your time.

Andrée Starå

@Connor Griffiths

Excellent!

You're more than welcome!

Glad you got it working!