AutoNumber or AutoPopulate Formula or Linked Cells
This seems like a very simple problem, but for some reason Smartsheet does not like what I am trying to accomplish. I am starting with a row of company information on grid that is a "Company Onboarding" sheet. When it hits a certain stage it is moved to a "Main Company" sheet. That works fine. I also need that same company information to show up on a "Company Task List". I would like the Company ID to be autopopulated on the "Company Onboarding" sheet then be carried through to the "Main Company" Sheet and "Company Task List sheet. But if I have the Company ID as an System/Auto Text column, it won't populate on the sheets its moving the information to because it says "Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet". Is there a workaround here?