Data design patternsReview and apply data design patterns. Model tables and columnsThe "item-detail" data patternThe "lookup/dropdown" data patternDesign your spreadsheetMake an "AppSheet-friendly" spreadsheetEffective use of column headersWork with a spreadsheet and the editorAssign cell formats in your spreadsheetSpreadsheet formulasMismatched spreadsheet formulasUse spreadsheets with pivoted dataGoogle Sheets having protected sheets or protected rangesApp design patternsMake your list into an app