Unable to create automation

Vinton Douglas

I am trying to obtain an automation where after midnight a sheet is copied over to a destination sheet. I keep getting this as seen in the image. Can anyone say what am I doing wrong?

Destination Sheet.png

Gia Thinh

Hi @Vinton Douglas,

Your source sheet has an existing system column (auto-number, created, created by,...), example ABC column. This requires your destination sheet also has a ABC column with the same property (system column).

In case the destination sheet has a ABC column with a differrent property then Smartsheet will notify the error like in your image.

You may want to double check the property of ABC column in the destination sheet .

Gia Thinh

Hi @Vinton Douglas,

Your source sheet has an existing system column (auto-number, created, created by,...), example ABC column. This requires your destination sheet also has a ABC column with the same property (system column).

In case the destination sheet has a ABC column with a differrent property then Smartsheet will notify the error like in your image.

You may want to double check the property of ABC column in the destination sheet .

Vinton Douglas

Thanks much.