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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!