Cross Sheet Reference With Different Column Headers

I have two separate sheets: one for projects and one for mentoring. The two sheets have some shared column headers and some different column headers.

When "Mentoring" is selected from a dropdown in the mentoring sheet, I need data from some of the cells in that row to automatically copy to the corresponding cells in the project sheet.

Obviously, the "copy row" feature doesn't work because it isn't a 1 for 1 comparison. How do I only have certain cells in each "Mentoring" row automatically copy to the corresponding cells in the other sheet?

Thanks in advance!

Find more posts tagged with

Accepted answers

KPH

If you want a true copy - a static duplicated copy of the data - then you can use the copy row automation and hide all the columns that you do not want.

If you want a dynamic reference to certain cells you can use an INDEX and MATCH or INDEX and COLLECT formula (or even VLOOKUP but it is less flexible) within the cells that you want to display the information from the Mentoring sheet.

https://help.smartsheet.com/function/index

All comments

KPH

If you want a true copy - a static duplicated copy of the data - then you can use the copy row automation and hide all the columns that you do not want.

https://help.smartsheet.com/function/index

wispsofsmoke

Thanks!!!

KPH

You are welcome @wispsofsmoke

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.