Did you know that the Teddy Bear was named after Theodore Roosevelt in a successful marketing campaign by toymakers? Explore this and other fun facts about all 46 US presidents in our United States Presidents spreadsheet.
Beyond introducing you to Andrew Jackson's foul-mouthed parrot named Poll, this spreadsheet uses several unique Spreadsheet.com features to organize, link together, and aggregate information about US presidents across multiple worksheets. For example:
Column C (Photos) in the Presidents worksheet is set to the Attachment data type, providing a place for presidential photos. The States worksheet also uses Attachment columns for state flag and state quarter images.
Column G (Party) in the Presidents worksheet uses the Related row data type to link presidents to rows in the Political Parties worksheet. Similarly, column M uses Related rows to link presidents to rows in the States worksheet.
Kanban views in the Presidents worksheet allow you to explore presidents by columns that use the Select data type, such as Religion and # of Years served.
Related row rollups are used in the Political Parties and States worksheets to calculate total number of presidents and years in office for each political party, by counting and summing data from linked rows.
John Quincy Adams' morning skinny-dip might be just enough inspiration for you to take the plunge and make a copy of this spreadsheet. Explore how these unique features work, and learn something new about US presidential history.
Before collating presidential factoids, our template team published 5 new templates in the Spreadsheet.com Template Gallery for use cases ranging from goal tracking to a new hire task list, and café inventory management.
For example, the new Quarterly Goals and Tasks template is designed for teams in any function to manage, assign, and track quarterly goals and associated tasks.
The New Hire Task List template provides a place to list onboarding tasks and internal contacts that can be distributed to new hires as they're onboarded.
Employee Performance Reviews(HR) Collect feedback from managers in an online form and log performance data for all of your employees.
Favorite Recipes(Personal) A simple place to organize recipes and their ingredients, tracking what you have on hand and what you need to buy.
Product updates
Whenever we release updates to the product we share more details of new features, enhancements, and fixes in the What’s New? section of the Spreadsheet.com Community. Recent updates:
Charts We’re working on adding the ability to create floating charts in worksheets that update in real time, including 14 different configurable chart types.
Grouping Based on popular request, we're adding the ability to group rows in Sheet views by unique values in a column with multiple levels of grouping.
Row Movement Ability to drag and drop rows to reposition them in a Sheet view. This includes the ability to move parent rows in a hierarchy and have all child rows move with them.
Gantt View and Project Management Improvements From enabling formulas in project management columns, to support for multiple types of dependencies, we have a whole set of Gantt view and project management improvements coming soon.
Borders 2.0 We're redesigning how borders work in Spreadsheet.com to better align with traditional spreadsheet behavior.
API We're working on publishing an initial version of our REST API that can be used to programmatically interact with Spreadsheet.com workbooks.
