Using DataMesh For Status Updates
Hey all -
Looking for a little help here. I've been using a combination of DataMesh the Copy function in SmartSheets to make a copy of a row when it changes to a particular status. Let me illustrate what happens here.
I have two sheets connected to each other. Sheet 2 (below) does a vlookup to Sheet 1 to get the status (I need that for something else). Since the Copy function won't work on a formula, I have a separate DataMesh process run and stamp the value of the status in another column. When that hits complete, the row is then copied to a Data Processing sheet.
It works, but I want to modify it to only take the columns I need now, so I want to switch to DataMesh for everything. So the problem I'm having is how to do it the best way. We actually use two Complete statuses (Complete, Complete Revised) and the challenge is it can go into Complete Revised several times over, and I want separate records logged in another sheet every time that happens. So in the end the data would look like this:
I just can't come up with a way to tell DataMesh (or a Report Filter) that it's a new record and to add it into the other sheet.
Thanks for any help,