I created a column for my "file path" that is supposed to output my report into SharePoint. I keep getting an "Unable to Open archive for zipping: ...." error although, I've checked my file path and don't see any differences between the actual path and what I've typed out.
Here is the file path that the reports are supposed to go to: C:\Users\RRead\Example\Team - Documents\SERIES - Dunning
And here is the formula for the path: "C:\Users\RRead\Example\Team - Documents\SERIES - "+[SERIES]+"\Reporting\Monthly SC Report\"+ [SERIES] + " - IAS Monthly Reporting "+DateTimeToday()+".xlsx|||ALL"
Note - the "series" is dynamic. This is what I have tried to illustrate in my formula.
