How do I make my formulas dynamic

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.

Workflow

Help

Accepted answers

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

Please check and advise if otherwise.

Many thanks

Shanker V

All comments

One way of doing this.

Many thanks

Shanker V

How do I make my formulas dynamic.yxwz

Hi,

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703