Multiple Rows

Options

Hello,

I have companies listed in one sheet (Main), and multiple contract numbers for each of these companies in another sheet. Is there a formula to match the contract numbers from the one sheet and add then to a new column in the Main sheet? The main sheet currently only has one line per company (parent), so I would need the formula to add rows (children) and note the contract number for each.

TIA!

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Hi @Deborah Tzuberi ,

    Will a report meet your need? Create a report from both sheets. Group by company. Contracts should appear below. You will need to use the same column names for the same data in both sheets.

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!