I am a bit new at this and am having a tough time getting this to work...
I have multiple sheets, one main one (Submissions) which receives data from a form, then I have the sheets: Level 1, Level 2, Level 3, Level 4, Level 5
When data (all text, into B:B) is received, I grade it manually with a number in C:C, still all within Submissions.
What I would like to do is sort this text data into the sheets based on the graded levels, 1 to 5, so data in B1:B1 graded level 1 in C1:C1 should go into sheet Level 1, while data in B14:B14 graded level 3 in C14:C14 should go into sheet Level 3.
I have tried my hand at
=Query with nested
=If with nested
=Query, but I'm definitely missing something and over my head...
Code for Level 1 sheet I had which seemed to make the most sense but does not work:
=IF(Submissions!C:C = "1", =QUERY(Submissions!B:C,Submissions!B2:B136),)