How to get Automation Email to work
Ive been trying to get an automated email to work since last September and had to give up back then, although thanks to Andree I made some progress and thought I had it fixed.
I enabled the automation for the first time this month after a couple of trials to myself and it doesn't work again. Smartsheet support are no help and I doubt from my experience that they will be.
Attached is what I am trying to do. Hopefully somebody can see where I am going wrong. I did change the method of calculating the cell that I look at, moving away from a complicated Excel style formula to something more intuitive but fail to see how that could influence it.
The Owners Column is setup as a Contact Column. This is an export as it's the only way I can see of sending a Smartsheet to somebody. I have redacted all the other recipients which are setup correct and we all receive emails from other automations in Smartsheet.