DTB Tools is a collection of Google Sheets tools created so you can work smarter, not harder. Tools include: dependent and nested dropdowns, auto-format and trim, custom IDs, percentage change.
适用于:
199
概览
DTB Tools was created to save you time and effort when using advanced Google Sheets. Instructions are at your fingertips: Clicking on “Help” in  DTB Tool’s menu gives you access to a  “User Guide” or lets you send a “Support” email. If you create the “DTB_Dropdowns” tab, you will see “Quick-Start Instructions” that are linked to the “User Guide”. Instructions are also provided in the menu’s popup boxes if you hover your mouse over the tooltips labeled i.
 
 
Features in DTB Tools:
- Custom dropdowns: Color codes invalid responses red so they can be filtered; and
Enables dependent and nested dropdowns up to 3 levels of nesting

- Format sheet: A suite of tools to quickly format sheets with frozen views, color filled headers, filters, and automatically adjusted column widths. Trims excess rows and column – even if array formulas add empty spaces
 
- Dynamic Percentage Change:Calculates percentage change for two columns of data; and Auto-updates with edits to data in either column
 
- Static Percentage Change: Calculates percentage change for two columns of data; and Date stamped to show date of calculation – does not auto-update
 
- Row ID numbers: Creates ID numbers for database functionality (example: PO-01567); and Includes refresh feature to add new ID numbers as new rows are added
 
- Numeric column labels: Inserts new first row that contains column numbers instead of column letters. Useful when using query to pull columns of data from one sheet to another.

The “User Guide” provides a link to a Demo sheet that can be copied and then edited to reproduce the screenshots.  For your security, the Demo sheet does not have any associated scripts.
其他信息
定价未提供
开发者
交易者状态未指定
DTB Tools”将请求获得以下权限。了解详情
DTB Tools”将需要访问您的 Google 账号
这样可让DTB Tools
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单