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


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.

Best Answer