I have attached a sample data that I have made to mimic my data.
What I have is a workflow that filters my data based on different criteria and I want to then create an excel workbook with a different worksheet that is named in the formula with the date and time that it is ran for each filter. I want to include the date and time in it because I will be running this workflow multiple times and want to see when it was ran easily.
I am not getting any errors when running my workflow but it is also not creating my excel workbook
Any help would be appreciated with this. Please let me know if there are any questions
For this I would try changing the whole "File / TableName" with the Sheet Name + DateTime value for each new sheet. Please see the workflow posted below. Please note that you will need to change the location that the outputs save to once you save the workflow on your machine.
When I change your output to mine and run it I get two different files and when I open it I get this error message. Any idea why this could be? Is it just something on my end? Also if I had 30 different filters would I just add 30 different block until done commands?