Report based on 3 sheets with the same primary column

Hi everyone,

i want to make a report based with 3 sheets (Financial informations, planning informations, others informations) which have a common reference in their primary column. I want to have all the informations automatically on the same line.

Please, can someone help me?

Thanks.

Find more posts tagged with

Reports

functionality

Accepted answers

Andrée Starå

@Jean-Daniel ADEGBIDI

I saw that Joachim answered already and he is correct!

We would either use a VLOOKUP or a combination of INDEX/MATCH to make it work.

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

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

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

Let me know if I can help with anything else!

All comments

Andrée Starå

Hi Jean-Daniel,

You would have to combine the information on another sheet first to be able to get it to show on one row.

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jean-Daniel ADEGBIDI

Hi,

Thanks for your answer. So, basically i can merge 3 sheets into one. But how can i automatically merge 3 lines from 3 differents sheets which have the same word (reference) into one line?

Joachim Mund

with vlookup in each column and reference to one of the three sheets, would that work for you?

Andrée Starå

@Jean-Daniel ADEGBIDI

I saw that Joachim answered already and he is correct!

We would either use a VLOOKUP or a combination of INDEX/MATCH to make it work.

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

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

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

Let me know if I can help with anything else!

Jean-Daniel ADEGBIDI

Hi,

Thanks for the help, i will try it.

Andrée Starå

@Jean-Daniel ADEGBIDI

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.