How to change the value of a cell depending on another cell

Nik · 03/11/22

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

David Tutwiler · 03/11/22

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

Nik · 03/15/22

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.

David Tutwiler · 03/15/22

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))

Nik · 03/15/22

https://community.smartsheet.com/discussion/comment/322708#Comment_322708

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:

David Tutwiler · 03/15/22

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.

How to change the value of a cell depending on another cell

Answers

Help Article Resources

Categories