Sheet not searchable in automation

I am having a recurring issue that my sheets set up for data moving is not searchable - see below:

Answers