Note: these steps are for Tiller powered Google Sheets only.

If you'd like to see a column that tracks the year for a transaction or balance history entry so you can create pivot tables or other reporting by year follow these simple steps:

  1. Insert a new column. To insert a new column right click any column header letter and choose to insert 1 left or right. We recommend adding it to the left or right of the month column.
  2. Paste this formula into the header row of the new column. 

=arrayformula(if(row(A:A)=1,"Year",year(A:A)))

In this forumla A represents the date column. If the date is in any column other than A update this formula to use the correct column letter before pasting it into the header row. 

As new transactions or balance history entries are added, the year will automatically populate into this column. 

Did this answer your question?