Tracking Happiness Diary – How To Edit Happiness Factors

the Tracking Happiness team
Written by

Published on , last updated on March 23, 2021

THD edit factors featured

This guide explains how you can edit happiness factors in your diary. This is really easy, but you have to follow the steps in this guide carefully. If you edit the wrong data, it could potentially result in errors down the line.

It’s advised to perform these steps while on a desktop/laptop. It can be done on mobile devices as well, but it will be a bit harder to select the proper boxes when you’re on a smaller screen!

If you encountered any issues during these steps, please contact us at [email protected].

Common errors

Changing a happiness factor is sometimes needed, and often a result of a mistake or typo when filling in the form.

For example, the happiness factors are case-sensitive.

THD edit factors common errors 1

If you add a happiness factor “Cycling” one day, and add another factor “cycling” the next day, they will be treated as unique happiness factors.

Additionally, adding spaces to a happiness factor makes them unique as well.

  • The factor “Stomach cramps” is different from “Stomach . cramps” (one space vs two spaces in between the words).
  • The factor “Stomach cramps” is different from “Stomach cramps ” (there’s a space at the end of the words).
  • The factor “Stomach cramps” is different from ” Stomach cramps” (there’s a space at the start of the words).

If you see any duplicates in your list of factors, this is likely the cause.

THD edit factors common errors 2

If this is the case, please follow the steps below to correct your happiness factors.

You can edit factors by updating your diary entries one by one, or you can edit factors in bulk. This article will explain both methods.

Again, it’s advised to perform these steps while on a desktop/laptop.

Open your personal database

Every email you receive from the Tracking Happiness Diary contains a link to your personal spreadsheet in the footer.

THD access your data here link footer

This link will direct you to your personal database.

This database is inside a Google Spreadsheet file, so you may need to sign in to your account in order to access it.

Once you’ve opened your personal database, look at the bottom of the page and click on the “Form Input” tab.

THD form input sheet tab

This tab stores the data that you’ve added via your form. The other tabs process this data so that it can be properly stored.

Editing previous entries can only be done in the “Form Input” tab! If you want to add new data to your diary, please follow our guide on “How To Import Data”.

It’s important to not change data in any of the other tabs. Also, the names of the tabs must always remain the same.

Editing a single happiness factor

The “Form Input” tab contains every entry that you’ve made via the form.

Each entry is stored in a row. The columns contain the form questions that you’ve answered with each entry.

THD form input edit data

Find the entry that you want to edit.

You can edit all the data in this sheet. But you have to make sure that you do not change the formatting!

Changing the happiness factors is done in columns C and D.

  • The positive factors are stored in column C.
  • The negative factors are stored in column D.

Make sure to place a comma and a space “, ” between each happiness factor! For example, “Running,Relationship” is incorrect, and should be added as “Running, Relationhip”.

You can add up to 10 positive factors and 10 negative factors per entry. If you exceed this number, any factors beyond the 10th factor will not be included in your dashboard.

Change a happiness factor that occurs in multiple entries at once

If you want to edit a happiness factor that occurs in multiple entries at once, here’s what you have to do.

Select the cells under Column C and D that you want to edit.

THD edit factors bulk 1

Go to the menu bar and click Edit -> Find and replace.

Alternatively, press Ctrl + H on Windows, or press Cmd ⌘ + H on Mac.

A “Find and replace” window will pop up.

Make sure that the “Search” fields are already determined, as in the image below. The “Search” field is set to a “Specific range”, with the range being the cells you already selected in the previous step.

THD edit factors bulk 2

Enter the factor that you want to change in the “Find” field.

Enter the value that you want to change it to in the “Replace with” field.

In the example below, the factor “Relationship” will be replaced with “Girlfriend” in the database.

THD edit factors bulk 3-1

Using the “Match case” option

It’s recommended to select the “Match case” option before making any changes. This could prevent the overwriting of factors that you don’t actually want to change.

Using the “Match entire cell contents” option

The “Match entire cell contents” should be considered before applying any changes.

For example, if you want to change the happiness factor “Work” to “Office”, you need to be aware of any factors that include the word “Work”.

If your database contains another factor called “Working on side hustle”, you have to use the “Match entire cell contents” option. If you don’t select this option, then all instances of the word “Work” will be replaced with the word “Office”. This would turn your other happiness factor into “Officeing on side hustle”. If you want to prevent this, you have to use the “Match entire cell contents” option.

Press “Replace all” and your database will be updated accordingly.

THD edit factors bulk 4-1

The window will show a message that indicates how many factors were updated.

If you want to revert your changes, you can always undo your actions by closing the “Find and replace” window, and going to the menu bar and clicking Edit -> Undo.

Refreshing your dashboard

Your personal dashboard sometimes needs 15 minutes to refresh after the data has been changed in your personal database.

If you don’t see any changes, please wait a moment and try again.

If you encountered any issues during these steps, please contact us at [email protected].


Follow us on Instagram