Google sheets

Data types

This is how we can create various data types in Google Sheets:

  • Dropdown list: Insert -> Dropdown

Date and time

To refer to the current date, we can use the TODAY() function.

Subscript and superscript

There is no direct way to format text as subscript or superscript. The easiest way is to copy the subscript/superscript characters from and paste them into the cell. A source for that can be the wiki page for Unicode subscript and superscript.

Google docs

Troubleshooting

Can't open a document on Android

This can sometime happen for large documents. The solution is to open the Google Docs application settings and clear both the cache and the app data.