Cell value changed

I would like help with the following:

I wish for a cell value to change to the same cell value of another cell based on what a third cell value is.

For example: First cell value is a dropdown in which I select Sold. Because I selected Sold I want a blank cell value to automatically be populated with the value on another cell which already had a number in.

Who can help me?

Find more posts tagged with

Accepted answers

All comments

Faaez Kamaal

Try this;

=IF([Column 1]@row = "Sold", [Column 3]@row, "Not Sold")

Make changes as necessary to match your sheet, but that should get you started.

Juan Garcia

Thank you

=IF([Column 1]@row = "Sold", [Column 3]@row, "HERE")

I want HERE to be the value already in another cell in the sheet.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.