How can i change the formula of a column when an element from a list in another column is selected

1

Hello, how can i change the formula of a column when an element from a list in another column is selected ?

For exemple in column 1 i have a list 1,2,3 and in column 3 i have the formula (column 2 * 10)
Now i want that when i select 2 in the list of column 1 the formula in column 3 change for (column 2* 20)

2

Hi @Maxime_Montoya :blush: !

Without a sample doc it’s a little bit hard to see what you want to do here :blush: … but if I get this right, you want to multiply the value in you column 2 by 10 * the value in your select list ?

So, if you choose 3 in your select list, the formula should do something like :

Column 2 * 30

If yes, I think you could just use a formula such as :

column 2 * column 1 * 10

Which should reflect that if:

Column 1 = 1 -> 1 * 10  => 10   ==> Column 2 * 10 
Column 1 = 2 -> 2 * 10  => 20   ==> Column 2 * 20
Column 1 = 3 -> 3 * 10  => 30   ==> Column 2 * 30

Now, if I’m completely wrong, could you share a sample doc with us so we could help you find the appropriate solution ? :innocent:

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.