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!
Answers
-
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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!
-
Hello,
I am hoping to get help on this issue. Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!