Ran into an issue trying to copy over a row to a destination sheet

Can anyone help me understand what this is? I have never ran into this issue before, but this now seems to be an issue.


Answers

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭

    @Meagan Harte

    That error message means exactly what it says. You have a non-system column in your source sheet that matches one in the destination that is a system column. System columns can be renamed, but they remain system columns. So if there's an AutoNumber system column in your destination sheet called "Record Number", and a Text/Number field in your source sheet also called "Record Number," you'll get this error. Rename one of the two matching columns and you'll be all set.

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!