Equity & Help Inc

Google Sheets cheat sheet Create and simultaneously edit spreadsheets with your team, right in your browser. Analyze data with charts and filters, hand...

Step 1: Create a spreadsheet To create a new spreadsheet: Open the Sheets home screen at sheets.google.com. Click New . This will create and open your n...

IF function Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Sample Usage IF(A2 = "foo","A2 is foo")...

Add or edit pivot tables On your computer, open a spreadsheet in Google Sheets. Select the cells with source data you want to use. Important: Each column...

Order and sort columns or rows You can sort and order your data by pivot table row or column names or aggregated values. On your computer, open a spreads...

Note: This feature doesn’t work for some numbers or currency formats. On your computer, open a spreadsheet in Google Sheets. Highlight the cells you want...

https://support.google.com/docs/answer/190718?hl=en&ref_topic=9055207

Open a spreadsheet in Google Sheets. Select the cell or cells where you want to create a drop-down list. Click Data  Data validation. Next to "Crit...

Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or ...

Insert checkboxes On your computer, open a spreadsheet in Google Sheets. Select the cells you want to have checkboxes. In the menu at the top, click Ins...