Please help this case

Hi everyone,

I want to create dynamic template on my sheet. I want create like this below are provided image.

I want to create a dynamic template that displays the first unique [Channel] where [Loat Status] is “Open.” The header should show a date range from the beginning of the current month to today(), the PDF should display data corresponding to that same date range and channel, as shown in the attached image. Is this possible?

I dont know where your data is coming from , but have you tried using the QUERY function.

3 Likes

My data in Google sheet. I want create template

It may be possible but I’ve not figured out how. When I last considered it, it all got really complex and confusing, so I abandoned it.

1 Like

What does your data look like?

1 Like

It is totally possible. Difficult to explain it, but i can do it for you, just send me a direct message to coordinate this work.

Regards!

1 Like