How to dynamically name the sheets in an excel ouput

Hello,

I'm trying to dynamically name my output excel file in my workflow so that it automatically updates with today's date and saves to a certain location. Thanks to other articles, I've figured out how to get it run with a single sheet tab in the excel file. However, I'd like it to generate multiple tabs in the report using my column [PID Desc]. I followed the format shown in other articles but I keep getting the error: "You must specify a sheet name." I'm including screen shots of my workflow. Any help would be much appreciated.

Thanks,

James

Developer

Accepted answers

Emil_Kos

Hi @James_Horton,

Maybe you can try to filter out the empty positions for the PID desc.

The first line is empty that is the only reason that I see why it doesn't work for you but it should start working when you changed it to sheet1.

I am truly sorry but I need to finish today. Maybe someone else will be able to assist you or you will get it working without any support.

Good luck!

All comments

Emil_Kos

Hi @James_Horton,

All the fields are string position?

Can you copy-paste the output from the OutputFilename column?

Emil_Kos

Hi @James_Horton,

It looks like your formula is correct. Maybe pip desc column is empty?

James_Horton

You're right. The PID field isn't populating in the name for some reason. It's set up as a string. Any ideas?

Emil_Kos

Hi @James_Horton,

Are you sure that PID Desc got any data inside? it isn't just empty or blank?

Test it with replacing pid desc with a formula that changes it to 'Sheet1'. Confirm if it will start working.

If it will you need to take a deeper look into PID desc. Without a data itself I am not able to do much 🙂

James_Horton

I"m unfortunately unable to provide data but here's a screen shot. PID Desc is populated. When I change PID Desc name to "Sheet1" it still doesn't work

Emil_Kos

Hi @James_Horton,

Maybe you can try to filter out the empty positions for the PID desc.

The first line is empty that is the only reason that I see why it doesn't work for you but it should start working when you changed it to sheet1.

I am truly sorry but I need to finish today. Maybe someone else will be able to assist you or you will get it working without any support.

Good luck!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335