tl;dr: I've set up the same workflow before but can't for this particular sheet.
I have set up many workflows and have not had an issue until today. I have a workflow for one particularly sheet so that when the work is done, the row will move to the archive sheet. For this example I will say that the Active sheet is "Intake Active" and the Archive sheet is "Intake Archive". This works with no issue and I confirmed today that when I try to set up a new workflow with both of those sheets, the Archive sheet is located. When I try that with two new sheets "IT/AB Active" and "IT/AB Archive" it will not find "IT/AB Archive". In fact when I'm in the "IT/AB Active" sheet and told it to search for "Intake Archive" it would not find it even though, as noted above, "Intake Archive" is being used in other workflows. I thought perhaps it is the "/" in the name I can see that is not an issue since it will find "IT/AB Weekly" and "IT/AB Monthly" but it will not find "IT/AB Archive".
The only thing that I can determine is that my Intake Active and Archive sheets are in a Workspace while the IT/AB Active and Archive sheets are in my Sheets folder. Could that be why it's not finding the sheets? That they have to be in a Workspace?? It doesn't seem to matter though that both sheets are in the Sheets folder.
I am an Admin on all of these sheets so that can't be it. Also the "about results" notes that it will only bring up the first 100 sheets with the name but in this case it's saying the file doesn't exist. What am I doing wrong?