How to change the value of a cell depending on another cell
I have a task, on a dropping list I have 3 row, each row according a value in another cell which should be change, example:
Dropping list on a b9 cell contains value a1,a2,a3
In a cell e9 I want to input automatically 10, 20 or 30, if
a1=10, b2=20, a3=30
Answers

I'm having a little trouble following your description. Could you post any screenshots to show what you're trying to do?

I'm trying to make cell E9 dependent of cell B9. If I select 1 of the 3 options from the dropdown in cell B9, I want to change the input in cell E9 automatically.

Gotcha. You're looking for an IF formula. In the cell you want to be dependant you would write something like:
=IF(B@row = A1, 10, IF(B@row = 20, 20, 30))

Seems like it's not working.
I have 3 options in a dropping list in a cell B9: L28, L79, L639. If I choose smth it should input data in a cell E9. L29 = 116$, L79 = 77, L 639 = 130. Following your example I got:

Are you trying to enter this formula in Excel? If so, it is a different syntax. I was assuming you were showing me the project in Excel and trying to replicate it in Smartsheet.
Help Article Resources
Categories
Check out the Formula Handbook template!