Reference Hundreds of Sheets

Hello,

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!

Find more posts tagged with

Sheets

Reports

References

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/123504/reference-hundreds-of-sheets

Hi,

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!

Best,

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!

MeganE

https://community.smartsheet.com/discussion/comment/441426#Comment_441426

Hello,

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!

MeganE

https://community.smartsheet.com/discussion/comment/441426#Comment_441426

Hello,

I am hoping to get help on this issue. Thanks

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.