How do I make my formulas dynamic

[ronn]

Greetings everyone,

I have multiple formulas that require me to modify a specific number.

Although I attempted to utilize the dropdown menu, it was not successful.

There are two types of formulas: static and dynamic. An example of a static formula would be [Number]/2, while a dynamic formula would be [Number] /[#1].

Rather than modifying each formula individually, I am hoping to change one number for explample in the dropdown menu and have all of the formulas update dynamically.

[ShankerV]

Hi @ronn 

One way of doing this.

Many thanks

Shanker V

[ronn]

Hi,

but If I choose now the number 5 nothing changes in test

[ShankerV]

Hi @ronn 

If the same data from the drop down needs to be updated to multiple formula tools, then you can use the below methos.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @ronn 

FYI, I have selected 5 and the test results are produced for [Number]/5

Please check and advise if otherwise.

Many thanks

Shanker V

[ShankerV]

Hi @ronn 

Please click on the below highlighted one.

So you will be able to change the numbers from the List box.

Many thanks

Shanker V