I make alot of spreadsheet guides for my clan

particularly those that specify which training methods are efficient at what income

 

I'd like to make it so the user can input his income.

however i do not know if it is possible to make so my published spreadsheets have a single cell where the user can edit

i know how to make the entire spreadsheet user editable, but then some troll ends up just deleting the whole thing.

 

if anybody knows I would appreciate it very much <3:

I don't believe it's possible to set it so that only certain cells can be edited, as the entire spreadsheet is one individual file.

 

Alternatively, you could set up an invite list in your clan, and set up a clan copy for them to use. Under the Share menu, go to Invite people, and only place people on the in-clan list on that invite list.