I have looked up responses but there are terms used that I do not understand.

I am using a Google form, and the information gathered is then pushed into a Google Excel sheet (responses). I need an if-then type of statement such as if the L2 cell text exactly is MTSS Collaboration/Consultation then that entire response row will be copied to the MTSS sheet (sheet 2).

IF the MTSS Collaboration/Consultation response is selected then that data will be copied to the MTSS sheet
IF Initial Evaluation, Re-Evaluation, or Special Evaluation is selected then the designated data row will be transferred to the Evaluation sheet (Sheet 3).

I appreciate any help in advance!

I saw a post that had something to the fact of =IF(‘Form Responses 1’ L1=”cyan” It was trying to support an IF the cell is X color then XYZ
But I do not see how that would transfer to another sheet

I tried to manipulate this =ARRAYFORMULA(IF(REGEXMATCH(M2, “Communication|Articulation|Pragmatics”),TRUE, FALSE))
to =ARRAYFORMULA(IF(REGEXMATCH(L2, “MTSS Collaboration/Consultation” but I have no idea how to indicate THEN copy row 2 data to MTSS sheet