Good afternoon all,
I am currently using Smartsheet to record hourly inspections on 13 machines we have in our factory.
As the inspection required for each machine doesn't change we have a master sheet, which I created a template from. The operators create a new sheet from the template each time the machine starts to make a new product; this sheet is then given a unique name [Product Number - Production Order Number]. We have a tablet on each machine for our operators to record their inspection findings on.
On the inspection report sheet our operators will also record any scrap that occurs during the production run. I would like to be sent an alert every time the operator records a certain number of scrap. However, the automation I set up does not work when creating a new sheet from a template. Is there a way around this? I've tried conditional formatting contact cells but when you put an email address into the contact cell it doesn't alert the person.
Would a form possible be able to do this?
Any help would be greatly appreciated.
Thank you.
