How do I create a table to keep track of specific data but also take dates into account?

Copper Contributor

I'm trying to create a table or graph of some kind to keep track of 3 distict things at the same time and I can't quite figure out how to do it:

1. Specific predetermined actions done 2. During a specific time period (like a class) while accounting for 3. The date that the actions took place. 


The time period and actions will be static, never changing, but I'm not sure if I can add the date in there or not. And even if I can't add the date (or just a general time period), trying to figure out how to graph the actions per time period as an ongoing thing (like put an x in a new cell for a new entry kinda thing)... 


Help please :)

1 Reply

Hi @Septus3,

create a new table with the following columns:

  • Date
  • Action
  • Time period

Then, enter the data for each row, with the date in the first column, the action in the second column, and the time period in the third column.

For example, if you are tracking the following data:

  • Action: Read, Write, Code
  • Time period: Class 1, Class 2, Class 3
  • Date: 2023-08-01, 2023-08-02, 2023-08-03

Your table would look like this:

Date Action Time period
2023-08-01ReadClass 1
2023-08-01WriteClass 1
2023-08-01CodeClass 1
2023-08-02ReadClass 2
2023-08-02WriteClass 2
2023-08-02CodeClass 2
2023-08-03ReadClass 3
2023-08-03WriteClass 3
2023-08-03CodeClass 3

Once you have entered the data, you can use the spreadsheet program to create a graph to visualize the data. For example, you could create a bar chart or a line chart to show the number of actions taken each day or the number of actions taken each week.

If you want to track the data over an ongoing period of time, you can simply add new rows to the table as new data becomes available.

Here are some additional tips for creating a table to track specific data but also take dates into account:

  • Make sure that the date column is formatted correctly. The date column should be formatted as a date, not a text string. This will ensure that the spreadsheet program can correctly calculate the date differences and create accurate graphs.
  • Use filters to view the data for specific dates or time periods. For example, you could filter the data to only show the data for a specific class or the data for a specific month.
  • Use conditional formatting to highlight specific data points. For example, you could use conditional formatting to highlight all of the rows where the value in the "Action" column is equal to "Code".

Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.

If the post was useful in other ways, please consider giving it Like.

Kindest regards,

Leon Pavesic