I have a spreadsheet that contains passwords so I can access them from anywhere. I make sure I always access it using https. However, I'm concerned that someone may steal my gmail password and access it so I wanted to add another security layer. I wanted to encrypt the passwords/on the page using a formula that encrypts each value using a master password.
That is, I would have a field on the spreadsheet where I'd have to type a master password so that the passwords display correctly, otherwise they would display as garbage
Basically this is the idea
I would need two formulas:
This formula would return the value that I would have to type into each of the password fields.
Cell Where the master password is
A1 = "MastrPWD";
Say I need to add a password of my xmail account which is set to "PAZZWD"
I would run the formula
which would return an encrypted value, say "BDUE45"
So in the line where I store my xmail pwd, I would set the formula of that line to be
B3 = Decrypt(A1, "BDUE45")
Then, I'd clear the field where my master password is set (A1), and even if somebody got access to my account, they still wouldn't be able to see the passwords unless they knew what to type into that master password field.
Hope this makes sense and somebody can help me