Copying contact information from one sheet to another
If my users attempt to copy contacts from one sheet to another, they loose the total contact information. Only the name, as text comes over. Even if both column types are Contact.
There does not seem to be an easy way to copy over a list of contacts.
Using copy rows is not an option - because the messes up the formulas that are built into other cells in the sheet.
Copying the sheet is also not an option. We use Control Center, when we start a new project, CC spins up a package of about 20 different project sheets, with multiple cross links and roll up reporting to PMO sub teams.
My users have project teams that have 100+ members on them. When they start a new project they want to go into an old project team sheet, copy the column of team members from that project and then paste it into the new project team sheet. They they add / delete as necessary.
Pre-populating the project team sheet will not work either. Often there is very little overlap between the teams of one project manager and an other project manager.