Coding Spreadsheets
Clean Up Messy Data in a Spreadsheet
I have a messy list in [SPREADSHEET_APP]. Here are a few example rows, with personal details replaced by fake ones: [SAMPLE_ROWS]. The problems I see are: [PROBLEMS]. Ple…
Coding · Spreadsheets
Stop typos in shared spreadsheets by adding dropdown menus and rules for what people can type.
Several people fill in the same spreadsheet in [SPREADSHEET_APP] and they keep typing things differently. The columns I want to control are: [COLUMNS_TO_CONTROL]. The allowed choices or rules for each are: [ALLOWED_VALUES]. Walk me through adding dropdown lists and simple input rules so people can only enter valid values. Give me the exact menu path for each step and tell me which cells to select first. If a rule needs a custom formula, write it for me and explain it in plain words. Also show me how to add a short help message that appears when someone clicks the cell, and how to colour cells that break a rule.
Tip: Put your list of choices on a separate tab so you can change them later without redoing the dropdowns.