I’m having an issue with the Statements template from Tiller Labs.

I know there are a lot of formulas in the spreadsheet which can limit the ability to perform some standard spreadsheet actions.

I am using the ‘Statements’ sheet. Because I did not add all of my current year statements in order, not all rows are in sequence. If I simply sort the range by column A, the arrayformula() function introduces errors.

Ex - Before sorting:

After Sorting on column A:

Note the blanks for the first two statements.

Simply copying the formula to the empty cells creates a #REF! error.

Looking at the cell contents before and after sorting, maybe I am missing something else, but I do not know what. Maybe just not getting the whole range since columns after L are hidden.

In any event, there should be an easier way to get the statement list in date order.

Statement Name formula:

`=arrayformula(if(isblank($C3:$C)+isblank($D3:$D),iferror(1/0),text($C3:$C,$A$2)&iferror("-"&RIGHT(vlookup($D3:$D,{INDIRECT($V$4),INDIRECT(vlookup(B2,{$T$3:$T$7,$V$3:$V$7},2,false))}, 2, FALSE),4),"-"&LEFT(SUBSTITUTE($D3:$D, " ", ""),10))))`