4 Replies Latest reply: Mar 7, 2016 2:55 AM by Andrea Bazzoni RSS

    Assign a value from 1 to 5 to a button or other object

    Andrea Bazzoni

      Hi everyone,

       

      i'm trying to assign a value from 1 to 5 to a button or any other object and i'd like to insert that selected value into an "IF" expression i have in a chart of the same sheet. This is my expression now: IF([CG Risultante]<3,3,[CG Risultante])

      The red value is now set in the expression, so i have to enter expression and change it manually. What i'd like to have is a reference to another object (button or something else) instead of the number to be able to change that value (range from 1 to 5) and consequently modifying the result of the "IF" expression directly from the object/button.

       

      Example:

       

      Button/object values allowed value: 1 - 2 - 3 - 4 - 5

      I select 2 -> The "IF" expression will use that value (2) as first condition (true)

      I change it to 4 -> The "IF" expression will use that value (4) as first condition (true)

       

      Note that i can't add variables or edit the script because i'm working on a shared document with limitations, is there any other way to do it?

       

      Thanks in advance,

       

      Andrea