How can I copy cells from another sheet with multiple instances of the Matched cell reference

RCruz
RCruz ✭✭
in Formulas and Functions

I'm new to the community, hello!

Scenario: I have a source sheet with time entries for all resources and all projects. Project ID appears in all rows.

I want to copy rows with the same Project ID’s into individual sheets, by sheet reference.

I am familiar with β€œIndex/Match”, but I do not know how to capture multiple instances, can anyone help?

· Share on FacebookShare on Twitter

Answers

  • bisaacs
    bisaacs ✭✭✭✭✭

    Hey @RCruz,

    Could you provide a sample of the data/sheets you're trying to Index/Match? This can help us better understand the information you're trying to gather. Please be sure to hide any sensitive information when providing the screenshot.

    Thanks!

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!

    · Share on FacebookShare on Twitter
  • RCruz
    RCruz ✭✭

    "Project ID 1" is used to match the records. My intent is to copy the Row and sum the hours for each User, in the destination sheet.

    Source_Data__Time_Entries_report.xlsx
    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!