Managing Bill & Regulation Sheets
Help with filtering, sorting and grouping bills and regulations; hiding bills and regulations; copying and archiving sheets; creating and managing templates; and creating rollup sheets.
- Blog Post
- Estimated Read Time 30s
- Getting Started
Legislator Export Tool ★
An explanation of how to export a spreadsheet with legislator information for a state.
- Blog Post
- Estimated Read Time 0:07:31
- Intermediate
Getting Your Account Ready for 2025 ★
A checklist of actions to prepare for a new session.
- Blog Post
- Estimated Read Time 0:13:18
- Getting Started
BillTrack50 - The Basics ★
A run through of the most fundamental functions of BillTrack50.
- Blog Post
- Estimated Read Time 0:02:40
- Getting Started
How to Make and Edit a Template ★
- Blog Post
- Estimated Read Time 0:02:42
- Getting Started
An Introduction to Regulation Tracking ★
An explanation of how to create and understand a regulation sheet.
- Video
- Estimated Watch Time 0:02:32
- Getting Started
How to Hide Bills ★
A demonstration of how to hide bills from your bill sheet.
- Video
- Estimated Watch Time 0:00:38
- Getting Started
How to Create a New Bill Sheet ★
A demonstration of how to make a new bill sheet.
- Video
- Estimated Watch Time 0:05:21
- Intermediate
How to Archive a Bill or Regulation Sheet ★
A demonstration of how to archive your sheet for backing up or examining trends over time.
- Blog Post
- Estimated Read Time 0:02:50
- Intermediate
Regulation Tracking Toolbox ★
An explanation of some good tips and tricks for searching registers and bulletins.
- Blog Post
- Estimated Read Time 0:03:23
- Getting Started
How to Use the Bill Sheet Grid ★
- Blog Post
- Estimated Read Time 0:05:52
- Intermediate
How to Create a Custom Column ★
- Blog Post
- Estimated Read Time 0:03:49
- Intermediate
How to Make and Use Roll Up Bill Sheets ★
- Blog Post
- Estimated Read Time 0:30
- Intermediate
Removing Bills From the Hidden Tab - 'Unhide All' or 'Update All'?
An explanation of the difference between 'Unhide All' and 'Update All' on the hidden tab.
- Blog Post
- Estimated Read Time 1:08
- Intermediate
Can't Copy a Bill to a Different Bill Sheet? Check the State!
An explanation of the importance of ensuring the receiving sheet has the correct state set up when copying a bill.
- Blog Post
- Estimated Read Time 0:02:07
- Advanced
How to Combine Bill Sheets
An explanation of how to use the Combine feature to create a temporary bill sheet containing bills from multiple sheets.
- Blog Post
- Estimated Read Time 0:08:50
- Intermediate
What Standard Columns Are Available on Bill Sheets?
A complete list of all columns that you can use in bill sheets, with descriptions.
- Blog Post
- Estimated Read Time 0:00:45
- Getting Started
The AI Summary Bill Sheet Column
An explanation of the bill sheet column which includes an AI-generated summary of the bill.
- Blog Post
- Estimated Read Time 0:04:12
- Advanced
How To Build a Regulatory Tracking Template
A run through of Michael O'Brien's comprehensive template for tracking regulations.
- Video
- Estimated Watch Time 0:01:47
- Intermediate
Can't Copy a Bill to a Different Bill Sheet? Check the State!
- Video
- Estimated Watch Time 0:02:36
- Intermediate
How to Create a Custom Column
An explanation of how to create your own columns to enter data into a bill sheet.
- Video
- Estimated Watch Time 0:02:57
- Advanced
How to Add a Custom Column For URL Links
A demonstration of how to create a custom column for entering web links to your bill sheet.
- Video
- Estimated Watch Time 0:01:02
- Intermediate
How to Copy a Bill to A Different Bill Sheet
A demonstration of how to copy a bill from one bill sheet to another.
- Video
- Estimated Watch Time 0:01:05
- Getting Started
How to Get Daily Alert Emails for Regulations
A demonstration of how to set up daily email alerts for regulation sheets.
- Video
- Estimated Watch Time 0:01:39
- Intermediate
How to Enter Data in a Custom Column
A demonstration of how to enter data in a column that you have created for your bill sheet.
- Video
- Estimated Watch Time 0:03:23
- Getting Started
How to Make a Template
A demonstration of how to create a new template.
- Video
- Estimated Watch Time 0:00:56
- Intermediate
How to Change Column Names
A demonstration of how to change the names of any columns in a bill sheet.
- Video
- Estimated Watch Time 0:05:49
- Getting Started
How to Use the Bill Sheet Grid
An overview of the grid and how to sort and filter bills.
- Video
- Estimated Watch Time 0:03:40
- Advanced
Using Grouping to Review a Legislative Session
A demonstration of how to use the grouping function to look back at a session and see what happened.
- Video
- Estimated Watch Time 0:01:17
- Getting Started
How to Filter the Bills in your Bill Sheet
An explanation of how to use the filter function in bill sheets.
- Video
- Estimated Watch Time 0:02:13
- Getting Started
How to Sort by Columns in a Bill Sheet
A demonstration of how to sort the bills in your bill sheet.
- Video
- Estimated Watch Time 0:05:44
- Intermediate
How to Make and Use Roll Up Bill Sheets
An explanation of creating and using roll up bill sheets.
- Video
- Estimated Watch Time 0:01:54
- Intermediate
Handling Special Sessions
A demonstration showing how to modify your bill sheet to add a column showing which session a bill is associated with, so that you can tell special session bills, regular session bills, and pre-filed bills apart.
- Video
- Estimated Watch Time 0:01:30
- Advanced
Data Synch Button
A demonstration of how to sync data you've entered for a bill on different bill sheets.
- Video
- Estimated Watch Time 0:07:15
- Advanced
How To Track When Hidden Bills Get Amended
A demonstration of how to check when bills you've hidden get amended in some way.
- Video
- Estimated Watch Time 0:06:14
- Getting Started
The Hidden Tab
A walkthrough of the hidden tab on bill sheets.
- Video
- Estimated Watch Time 0:09:10
- Getting Started
Rolling Over - Managing Individual and Hidden Bills
A demonstration of how to manage bills and hidden bills when rolling over your account for a new session.
- Blog Post
- Estimated Read Time 0:07:31
- Getting Started
Getting Your Account Ready for 2024
A checklist of actions to prepare for a new session.
- Blog Post
- Estimated Read Time 0:03:47
- Advanced
How To Track When Hidden Bills Get Amended
- Blog Post
- Estimated Read Time 0:02:20
- Advanced
Regulation Advocacy
An explanation of some good strategies for effective regulation advocacy.
- Blog Post
- Estimated Read Time 0:04:39
- Intermediate
Template Columns
An explanation of the 'Date Added', 'Has Companion' and 'Last Amended Date' columns in a bill sheet.
- Blog Post
- Estimated Read Time 0:05:00
- Getting Started
Workflows
An explanation of how to organise your account.
- Blog Post
- Estimated Read Time 0:02:45
- Intermediate
Filter Your Bill Sheet by Session
An explanation of how to use a template and then filter to identify bills from a specific session.
- Blog Post
- Estimated Read Time 0:03:43
- Getting Started
What Are Regulations?
An explanation of what regulations are and what they do.
- Blog Post
- Estimated Read Time 0:04:31
- Getting Started
How to Filter the Bills in your Bill Sheet
- Blog Post
- Estimated Read Time 0:05:22
- Advanced
Flexible Customization Options
A run through of how we can help you if you need to do something out of the ordinary.