If you need more help, please share a copy of your spreadsheet with dummy but realistic data so that the fine members of this forum can take a look. Go through File > Make a copy, then in the new copy of the spreadsheet dummify the contents and follow File > Share > Who has access > Change... > Anyone with the link > Access > Can Edit > Save (note especially the "Can edit" setting.) Then copy the address in the "Link to share" box in the File > Share dialog box and post it here, together with as concrete a description of your scenario and questions as possible.