1 Reply Latest reply on Jul 11, 2018 12:10 PM by Mavis Liu

    How to Make a DropDown that Applies Different Weights?

    Emily P

      Hello,

       

      I want to allow users to be able to select if they want a value to have Low, Medium, or High significance in the Total Score.  So for example, there would be a drop down (Low/Medium/High) above each column.  If they select Low it will make each value in the column Value*.5, if Medium... Value*1 (or just the value), and if High... Value*1.5. 

       

      I attached a workbook with the data setup I am working with.  Anyone have some pointers on how to go about doing this?

       

      Thanks!

      Emily