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.
Fungerer sammen med:
199
Oversigt
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.
Yderligere oplysninger
PrisIkke tilgængelig
Udvikler
Forhandlerstatus er ikke angivet
DTB Tools anmoder om de tilladelser, der er angivet nedenfor. Få flere oplysninger
DTB Tools har brug for adgang til din Google-konto
Dette giver DTB Tools tilladelse til følgende:
Se den primære mailadresse på din Google-konto
Se dine personlige oplysninger, heriblandt personlige oplysninger, som du har gjort offentligt tilgængelige
Anmeldelser
Sprog:
Sorter efter:
Google verificerer ikke anmeldelser eller bedømmelser.Få flere oplysninger om anmeldelser
Ingen kommentarer
Søgning
Ryd søgning
Luk søgning
Google-apps
Hovedmenu