Legal
Recommended Products
-
Westlaw
Conduct legal research efficiently and confidently using trusted content, proprietary editorial enhancements, and advanced technology.
-
Practical Law
Accelerate how you find answers with powerful generative AI capabilities and the expertise of 650+ attorney editors. With Practical Law, access thousands of expertly maintained how-to guides, templates, checklists, and more across all major practice areas.
-
HighQ
A business management tool for legal professionals that automates workflow. Simplify project management, increase profits, and improve client satisfaction.
Questions? We are here to help
Tax & Accounting
Recommended Products
-
Checkpoint Edge
Unleash the power of generative AI through an accounting and tax research tool. Find answers faster with dialogue-based research and quick, on-point search results.
-
UltraTax CS
Provides a full line of federal, state, and local programs. Save time with tax planning, preparation, and compliance.
-
SurePrep 1040SCAN
Automate work paper preparation and eliminate data entry
Questions? We are here to help
Trade & Supply
Recommended Products
-
Foreign Trade Zone Management
Software that keeps supply chain data in one central location. Optimize operations, connect with external partners, create reports and keep inventory accurate.
-
Indirect Tax
Automate sales and use tax, GST, and VAT compliance. Consolidate multiple country-specific spreadsheets into a single, customizable solution and improve tax filing and return accuracy.
Questions? We are here to help
Risk & Fraud
Recommended Products
-
CLEAR
Search volumes of data with intuitive navigation and simple filtering parameters. Prevent, detect, and investigate crime.
-
Fraud Detect
Identify patterns of potentially fraudulent behavior with actionable analytics and protect resources and program integrity.
-
ID Risk Analytics
Analyze data to detect, prevent, and mitigate fraud. Focus investigation resources on the highest risks and protect programs by reducing improper payments.
Questions? We are here to help
News & Media
Recommended Products
-
Reuters Connect
Around the globe, with unmatched speed and scale, Reuters Connect gives you the power to serve your audiences in a whole new way.
-
Reuters Plus - Content Studio
Reuters Plus, the commercial content studio at the heart of Reuters, builds campaign content that helps you to connect with your audiences in meaningful and hyper-targeted ways.
-
Reuters.com Platform
Reuters.com provides readers with a rich, immersive multimedia experience when accessing the latest fast-moving global news and in-depth reporting.
Questions? We are here to help
Books
Recommended Products
-
What's new in legal products
Shop our latest titles
-
Shop tax customer favorites
ProView Quickfinder favorite libraries
Questions? We are here to help
Developers
-
APIs by industry
-
Related sites
-
United States Support
-
International support
-
New releases
-
Join a TR community
-
Free trials & demos
Determine GoFileRoom drawer file size
Summary
To find the total size of a drawer you can export a list of details about the documents in the drawer to Microsoft Excel. You can then use a SUM formula to calculate the total file size of all the documents in the drawer.
Before you start
Make sure that document security measures won't prevent you from seeing a full list of all the documents in the drawer.
Use a search to get a list of documents and export it to Excel
- Go toSearch Documents, thenClassic Search.
- Select aDrawer.
- Enter an asterisk (*) in theClient Namefield, then selectSearch.
- Make a note of the total number of documents.
- SelectOptions, thenExport List.
- SelectOpento view the search results in Microsoft Excel.
Use Excel to calculate the total file size of the drawer
note
The exported list includes the file size of each document in the drawer. Before you can use a SUM formula in Excel to calculate the total file size, you'll need to remove the letters
KB
from the File Size column so that only numbers remain.
- With the exported list of documents open in Excel, highlight the File Size column.
- PressCtrl+Fto open Find and Replace.
- Select theReplacetab.
- EnterKBin theFind whatfield.
- Leave theReplacefield blank and selectReplace All. The number of replacements should equal the total number of documents that you noted in the search results above.
- SelectCloseto finish with Find and Replace.
- In the File Size column, go to the last cell that contains data. Enter a SUM formula in the next empty cell to calculate the total size of the documents in the drawer.
tip
You can read more about using a SUM formula in Excel on Microsoft's website.
If the customer can't get a full list of documents from Search, or can't export it because they're receiving an error or the database is too large, email the GoFileRooom systems team with the Firm ID and database ID and ask them to find the drawer size.