Change both Excel workbook name and Excel worksheet name

Question

I have attached a sample workflow that will change the Workbook name with a dynamic date. What I want to be able to do is also change the worksheet name to something at the same time and cannot figure out how to do both at once.

Any help would be greatly appreciated

Thanks

Sample Workflow.yxmd

DataNath · Accepted Answer

@Travis_Ratliff when you say you want to change the worksheet name to something, what is that something? If you want to split the output Excel file based on a field for example, you can reference it like so:

However, if you just want it to be something that you type in and hardcode, you can just replace where you were previously using 'sheet1' at the end of the custom filepath you're making:

Likewise you can use dynamic functions again like you have with the datetime for your filename.