With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Saturday, January 3, 2015
yogi_WorkAround To Display Corresponding Name From A Number In A DropDown List
post byJeff - Hudson Valley Giclee: https://productforums.google.com/forum/#!mydiscussions/docs/h0PMMxWwA1I Drop down menu shows words but reflects a number
Ive been looking for some time now and cant seem to find (or even know how to look) for an answer. I want to create a drop down menu in google spreadsheets that shows a name. The names value, however, will be a number. When that name is selected, the number is activated in an equation somewhere to reflect a change in that equation. An example:
Bar of soap:$8
When you drop down the menu for bar of soap and another drop down is quantity, would reflect the change in the equation. but the drop down would show the name of the product, not the number. And a side question: I get errors when I validate numbers when they have been rounded up with a price. Is there a way to prevent those errors? I cant wait until you brilliant forum readers can help me!