I have a spread sheet that i am using to tally points given in a slack channel. We are using Zapier to listen to messages and when the filter criteria are matched it takes the message and inserts it into a spread sheet.
What i am doing is taking the raw data into a second sheet to parse out the points given and the person they are to go to. I'm using "=Raw!$A2", to copy the rows to the new sheet and then an equation to parse the message into "Real Points" and "Real Recipient ". THe equations for the data copy and the parsing are just copied down The issue i am having is that when a new row is inserted (by zapier or inserting manually) the equations are all thrown off. here is a copy of the sheet to mess with https://docs.google.com/spreadsheets/d/13wH675INbJGhFInf5fuaHLEnkvPLxnt42ujxg2Vknko/edit?usp=sharing -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
