Thanks for the replies. This is hard to explain, but the way the number sign is used is actually as a name/description rather than an actual number though so it is preferential to keep it this way. That’s why I haven’t just added the # as a permanent part of the file name. My client has a set of customers whose cranes they inspect. Sometimes the cranes have actual unit numbers, and other times they use a descriptor, like the above, where they are saying that the crane belongs to the #2 Well. These descriptions come from their customers so changing them isn’t really an option.
Is there any reason why this is working in my other app where I’ve used the old workflow/save file method, but it doesn’t work with automation? EDIT: I am mistaken, it’s another field I’m thinking of that isn’t part of the file name.
Is there a way I can change the # to a - for writing the file name to the column so it matches how it’s saved in Drive?