May 03 2021 08:09 AM
Hello. I have a shared spreadsheet with table in it. It includes data validation and one formula. Other individuals either directly enter information or copy and paste from other sources. The direct entries are no problem, as the drop downs and data validation work well. When information is pasted from an outside sheet though, it is very easy to paste the external formulas and formatting, which can "mess up" the table and cause the need to "repair" it, which takes time.
I've requested they paste values only, but this scenario is still happening. Is there a way to control pasting and only allow values to be pasted?
Thanks,
Aaron
May 04 2021 08:16 AM