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

Find more posts tagged with

Accepted answers

All comments

David Tutwiler

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

Nik

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

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

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

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.