Sheet to populate another sheet?
Looking for a way to minimize damage (deletion of rows of data) of a critical - and very large - sheet. Seems there's a 'glitch' that causes this and it's happened twice in the recent past. Things I thought of but don't think will work... "locking rows" doesn't work b/c team needs to edit/update frequently; creating a "form" for data entry doesn't work b/c they need to see the info in the other row cells (it's basically a call log).
? - Is there maybe a way to prevent deleting but allow editing?
? - Create 'child' sheets where each person has a "sub-sheet" with their rows and their entries feed into a 'master' sheet with collective data?
Anyone? Anyone? lol
I've only been using Smartsheet for two weeks so appreciate ANY help I can get. Thank you in advance!