A little background here: I use Smartsheet primarily to track lab testing and release on each lot of our products. I have almost everything configured so all of the work is done automatically, but there's one piece I can't figure out.
When the lab sends me an export file of all of the results, sometimes the values that are returned are for several lots of product (tested as a "composite"). For example, if we have a sample tested at the lab as "X0111-X0119 COMPOSITE", those results will apply to all of the lots X0111 through X0119. My main sheet uses DataMesh to pull the results from the lab data and put it in the right row so I can generate a Certificate of Analysis for the customer (matching primary column product and lot numbers between the two sheets). What I would like to do is for Smartsheet to recognize when I have one of these "composite" rows and trigger the creation of x number of rows with duplicate results given the total number contained in the "composite" row.
I've tried to do this a number of ways with automation, but it stops after a few iterations and gives me an error message, since the automations are triggering each other in what Smartsheet thinks is an infinite loop.
Anybody have any ideas?
