Updating cells based selection drop down list data validation
As we work to improve this experience, we are going to be conducting some Usability Studies from July 5th-July 13th.We expect these sessions to only last about an hour.This is just a simple example that might be used in an office environment, and we’ll go through this example throughout this post.And before we get into the specific points of each method, read on to find out about the Data Validation feature which is a key part of setting up a drop down menu in Excel.Here’s how you can have a photo change based on the selection from a dropdown list in Excel: You can download the file here and follow along.If you get a preview, look for the download arrow in the upper right hand corner. My name is Mike Rempel and I am certified as a Microsoft Excel 2010 Specialist.If you are interested, please fill out this webform and include 2-3 times between July 5th and July 13th that might work for you. EQBCT=bbccacf667424ef1bbe8f43a5fd02144 The focus group for this went well, at least from my perspective.
A question I get asked from time to time is: how do I create one of those drop down lists in my Excel sheet?
We'll know the timing better as we get closer to the ship date. We are wrapping up development of data validation and expect to deliver it in the next 1-2 months, so please stay tuned. We're always interested to hear specific scenarios from customers, which we incorporate into our feature development. So very happy to hear that this is just around the corner.
In the meantime, in case it's helpful: you could apply a Conditional Formatting rule to color data yellow or red if it does not match a dropdown choice. As for usage methods: We use SS to track our installation projects, which can last anywhere from 1-3 years.
Best regards, Daniel Hi Daniel, In exactly one week, three months will have elapsed since you announced that data validation settings would be delivered to Smartsheet, and I am yet another user who needs to immediately benefit from this addition that I'm still very surprised was not a basic functionality from the beginning. We ask that the people record their hours used in one cell, and then have another cell where they can record their hours lost.
Next to that field is a "reason" field, where they select from one of a few categories of time loss reasons: documentation, missing parts, part failures, etc.