Automation Error

KC Jones

Not sure if this is the right place for an automation error or not. I have previously asked about returning a value once (not sure if my link would work for everyone or not). I was able to get it to work with a metrics sheet, a helper column, and a copy rows automation. However, the ID I used for that one, is only valid for the ongoing project I tested it on. I tried to change it to another identifier for our other projects that have a start and end date.

Unfortunately, I kept running into errors. I thought I had finally gotten it all worked out, but I realized the automation was blocked. I attempted to make every sheet standard, which meant hiding columns in any project that doesn't need it. That way our ongoing can be pulled in with other projects for reporting. I've never gotten this error before though. The system columns were the same so I even tried to change that in the metrics sheet, but no luck. I have searched online and can't seem to find any information on actually fixing it. I think I found one that said to rename them, which I did.

KC Jones

For the original question regarding the creation of this automation:

https://community.smartsheet.com/discussion/90539/trying-to-return-a-value-once-but-not-when-cell-value-changes#latest

Toufong Vang

The errors means that you have a non-system column in the target sheet that has the same name as a system column on the source sheet. Convert that column (in the target sheet) into a system column to match the one on the source sheet, or change its name.

For example, I will encounter that error if my target sheet has "Requested by" and it is a Text/Number column type while my source sheet has "Requested By" but it is a Created by column type.