In this article:

Free Pros and Cons Template for Google Sheets (2024 Update)

November 12, 2024

In this article, we will show you how to use our pros and cons template in Google Sheets. Read on to learn more!

pros and cons Google Sheets template

Free Google Sheets Pros and Cons Template

You can make a copy of this pros and cons template in Google Sheets for free. Don't request for permission to edit, simply go to File > Make a copy.

google sheets template for pros and cons

How to Use the Pros and Cons list Template in Google Sheets

Below, we explain how to use our pros and cons template in Google Sheets: 

1. Identify the Topic

Enter the topic you're evaluating in the first table. In this example, we’re reviewing a "Remote Work Policy."

simple pros and cons google sheets template

2. List Pros and Cons

Enter the pros and cons in the second table. For example, a pro could be "Flexible schedule," and a con could be "Harder to collaborate in real-time."

editable pros and cons template in sheets

3. Assign Scores

Assign a score between 0 and 10 for each pro and con, based on its importance. Enter these scores in the "Pros Score" and "Cons Score" columns.

fillable pros and cons template google sheets

4. Automatic Score Updates

The cells for the score sums contain formulas. Whenever you assign a score, the totals will automatically update, either adding or reducing based on the assigned scores.

pros and cons template made in google sheets

5. Analyze the Results

Compare the total scores for pros and cons. If the pros outweigh the cons, the decision may be favorable. In this case, the pros total 84, while the cons total 54, suggesting the policy's benefits outweigh its drawbacks.

free template pros and cons in google sheets

Feel free to customize this layout based on your specific needs! 

We hope you now have a better understanding of how to use our pros and cons template for Google Sheets.

If you enjoyed this article, you might also want to check out our Google Sheets food diary template and lesson plan template for Google Sheets

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->