Critical improvements to Sheets needed
A list of critical improvements for sheets in order for me to want to keep using it.
-When making a cell in one tab refer to a cell in another tab, I want there to be a possibility to make the reference go both ways. So if I make a change to cell A1 in Tab I, it automatically changes the information in corresponding cell in Tab II and vise versa.
- The option mentioned above but between two files, not just tabs. As has been mentioned many times before in this community
-The ability to permanently link two cells. So if cell A1 contains a name and cell B1 contains a phone number, they should be linked permanently, until I unlink. The information cannot accidentally get mixed by a silly human error.
-The ability to change the formatting of a cell to 'text only' in order to not constantly have to deal with jumping and changing numbers etc.
-The formatting of a grid should be able to automatically apply when I insert a new row. Currently I made a grid with a chessboard-like color formatting to improve readability. Whenever I add a row or column, I have to manually shift all of the formatting of the entire grid.
-supplementing the previous point: I want to be able to copy/paste the data of a cell WITHOUT the formatting. But also be able to copy/paste the formatting of a cell WITHOUT the data. I keep having to copy and past "in the right order" or everything will turn into a massive mess.
For now I will keep using sheets because I am stubborn and commited to Proton - I decided to pay for my subscription and want to make it work.
But simultaneously I am on the brink of switching to any functional alternative at this point.
Sheets is making some simple tasks more complicated and time consuming rather than easier, at this point. Which goes in against the whole goal of launching such a function in the first place.
Improving the functionality of this program should be relatively easy for people with the right skill sets (which I am certain you have working for you, Proton), please make these basic functionalities a priority for your userbase!