Output to Template with Merge Cells

Question

Hi Guys,

I would like to ask for your expertise on how are we going to enter the following fields in a merge cells using a template. The output should be look like this.

Attaching the template for your reference.

Looking forward for your assistance.

Thanks,

Kamen

Template.xlsx

atcodedog05 · Answer

Hi @KamenRider

You need to configure to specific ranges like this. This setup is working for me.

It's not possible to create dynamic header creation while using a template file. Refer to option 2 for dynamic header creation in reports.

Hope this helps : )

write to template.yxmd

write to template.yxzp

KamenRider · Answer

Hi @atcodedog05

I apologize, I don't have workflow outside the office. But then I have created an screenshot for you to visualize. As I said, each input file has its month and year. I have

tried combining the 3 months in one input file but the other two is not appearing in the workflow. I'm not sure why? Also I would like to connect those months in the email using a formula tool stating "From May to July Review" where if it is possible for May and July to appear at the end without manually typing it.

Please let me know if you still have inquiries.

Looking forward. Thanks,

Kamen

atcodedog05 · Answer

Hi @KamenRider

Can you please share with me the workflow you have tried? I can take a look into it.