[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_button admin_label=”Google Sheet Button” button_url=”https://docs.google.com/spreadsheets/d/11XPTZQLwgnaCLZP6GZ40EAZKmdqy0puShIu_NOWDYO4/edit?usp=sharing” url_new_window=”on” button_text=”Get the Google Sheet Template Here” button_alignment=”center” background_layout=”light” custom_button=”on” button_letter_spacing=”0″ button_use_icon=”on” button_icon=”%%97%%” button_icon_placement=”right” button_on_hover=”on” button_letter_spacing_hover=”0″ button_text_color=”#e00b00″ button_bg_color=”#edf000″] [/et_pb_button][et_pb_text admin_label=”Text”]
You may be wondering, why this is important. There are two major reasons why it’s important to create drop down menus in Google Sheets, when you’re using Google Sheets in Accounting for Startups.
You want to make sure certain things are consistent. A name for example. We don’t want typo’s creating different versions of the same name. That would result in information being incomplete when we try to report on the activity for a particular name.
The other reason, is it saves time on data entry. Rather than having to type the same thing, over, and over, you can choose it, in a click.
I’m also going to show you, how to use a lookup, to bring in additional information. In the previous segment, on Bootstrapping your Accounting with Google Sheets, I laid out the columns for you. Next to the “Name” column, we had “Name Type.” We’re going to create this, and then use a vlookup formula, so that when you choose a name, from the list, it’s type will be brought in, automatically. This will save time, and also minimize the chances of data entry errors.