Statements Sheet has all accounts combined into one name, with that name as only option

Google Sheets
1

The account field (col D) of the statements sheet has a drop down, but it only has one option with all my accounts listed as a long combined single string of text, rather than each account as a separate option.

The data validation refers to P3:P, which unsurprisingly also has just this one option. The formula in cell P3 is =iferror(QUERY({INDIRECT(V4),INDIRECT(V5),INDIRECT(V7),INDIRECT(V6)},“SELECT Col1, Col2, Col3 WHERE Col4<>‘Hide’ AND Col1<>’’ ORDER BY Col2, Col1”))

Help please!

2

That formula is exactly the same as what’s in my sheet. Does your Accounts sheet look normal (accounts each on a separate row instead of all in once cell)? You might try ‘Restore Sheet’ in the ‘Manage Solutions’ to see if that fixes the issue.

3

I don’t know why, but ‘restore sheet’ fixed it. Thanks!

1 Like