Updating rows with Zapier
I have to two identical sheets and would like to have the (child sheet) or sheetB we'll call it for the purpose of the exercise, update whenever changes are made to the parent sheet or sheetA. Currently, I am executing this task manually by going to sheetB and linking the rows back to sheetA. What I would like to do is create a Zap with Zapier to automate this action when triggered by changes made to the sheetA. Unfortunately, the problem I am having begins when I tried mapping the data between the two sheets which requires a "RowID" to complete the mapping process. Regrettably, there isn’t a "RowID" option to select. Is it possible to achieve this at all? Any help would be greatly appreciated.