Unable to create automation

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?


Best Answer

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    edited 03/22/22 Answer ✓

    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 Co. - Smartsheet Solution Partner.

Answers

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    edited 03/22/22 Answer ✓

    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 Co. - Smartsheet Solution Partner.