Index Collect returning invalid value

Hello, I am using an Index collect formula to collect data from another sheet based on a unique ID entered in a sheet. Ultimately, I am trying to copy data form rows in another sheet however I don't want to use the copy row function because I only need specific fields Therefore I have created a new sheet that if the ID is typed into the ID field each column will use the index collect formula to collect the data needed based on the row ID.

Here is my formula for the current status field:

=INDEX(COLLECT({Current status}, {Row ID}, ID@row), 1)

I want to populate this sheet:

Here is the source sheet where I am retrieving status:


Answers