Reference Hundreds of Sheets



I have hundreds of sheets that represent individual contracts. Every time contract is renewed, the current year is added to the sheet. I use a report to reference all the contracts and bring in information for the current year.

I want to compare the year's contracts against the budget so I created a new sheet and I tried referencing the report, but that doesn't work. It's not feasible to write out each contract into a formula so I was wondering if anyone has suggestions.

Thank you in advance!


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭


    I hope you're well and safe!

    Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    I hope that helps!

    Be safe, and have a fantastic day!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • MeganE
    edited 06/19/24


    I hope I can provide enough info. The first sheet is a sample of one of my many contract sheets. These values are manually input.

    Second two photos are from a sheet where I am trying to compare the current year funding. The orange/beige cells are manually input from an annual budget. The green cell is manually input based on the project number it is assigned to (in another sheet). The green cell will fill in the project title from the other sheet along with some other info such as the following cells "P/D PMI PM, P/D PMI PMFirst, etc." The data after "Column 49" is where I want to pull it from the Contract Sheet. "NEW or Amend" and "AV Date/AV No." and so on.

    I was hoping that I could somehow use the Budget Number (which is on both sheets) to bring in the other info from the contract sheet as long as the Fiscal Years are the same.

    Please let me know if I can provide any additional info. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!