Row copying over twice
Our Metric Archiver tracks the number of units we recieve, wash, process, etc. daily. The last 2 years we have only been dealing with towable units. We recently brought in motorized units, so I updated colums to reflect towable and added columns to reflect motorized. Here is a screenshot of that sheet.
This sheet is to copy the row over to the Archive Metric sheet at 10pm every night.
It is still copying over but is copying twice and I'm losing my mind.
Not only is it copying twice, but the columns are stressing me out too. Example--the Towable Drop Off column used to just be 'Drop Off' but I renamed it to Towable, changed the formula, and then added a motorized drop off column. When it copies over, I have the towable and motorized drop off columns that I want, but it is still showing the origial 'Drop Off' column I thought I got rid of--and all but one of the columns add up correctly. Here's a visual:
Can someone help explain why this is happening?
Help Article Resources
Check out the Formula Handbook template!