Feb 21, 2022

Happy Presidents Day 🇺🇸

Matt Robinson
co-founder & CEO

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.

United States Presidents

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:

  1. 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.

  2. 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.

  3. 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.

  4. 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.

New Templates

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.

Quarterly Goals & 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.

New Hire Task List

The Café Inventory Management template is designed for tracking store inventory, manufacturing or purchase costs, and revenue.

Cafe Inventory Management

Other newly published templates include:

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:

What's next?

A few features we're busy working on now:

Stay tuned for more updates coming soon ...

More blog posts ...