Google docs merge add-on is not working if based on a report

Joachim Mund

Hi all,

I try to build a google doc based on a report, but every time I select the report the following error message is shown:

Report Selected

You have selected a report. For the Merge process to work, please make sure that the title of the Primary column in your report is the same as the primary column in the sheet.

Both sheet and report has the same title for the primary column.

Any idea?

Thanks and best wishes, Joachim

Joachim Mund

Hi @Andrée Starå

it works! I opended the google doc again and started "smartsheet merge".

The report was suceesfully accepted from my tries yesterday where I renamed the primary columnn in the report to the same name as the underlyng sheets primary column.

I was able to select the filtered rows of the report and generated a google document and a PDF file.

This is a great feature which gives us new functionality for the smartsheet google docs merge add-on!

e.g. I can filter now my sheet in the report and give the users a better overview and reduced rows to select.

I wish you a fantastic sunday

Andrée Starå

Hi @Joachim Mund

Unfortunately, as far as I know, it's not possible to use google docs to merge from a report now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Joachim Mund

Hi @Andrée Starå

it works! I opended the google doc again and started "smartsheet merge".

The report was suceesfully accepted from my tries yesterday where I renamed the primary columnn in the report to the same name as the underlyng sheets primary column.

I was able to select the filtered rows of the report and generated a google document and a PDF file.

This is a great feature which gives us new functionality for the smartsheet google docs merge add-on!

e.g. I can filter now my sheet in the report and give the users a better overview and reduced rows to select.

I wish you a fantastic sunday

Andrée Starå

@Joachim Mund

That is excellent news!

A couple of years ago, it didn't work, and I was also in contact with Smartsheet Support about it because it looked like it should, and they informed me that it wouldn't, so something has been updated or Support had the wrong information. In any way, glad it works. It will be handy for some of my clients.

Thanks for letting me know!

Have a fantastic Sunday!

Joachim Mund

@Andrée Starå

yes it is a great functionality, but it appears that there are some limitations:

1. contact columns are not recognised as email thus email sending can not be configured
2. dates like "22.08.21" are shown in the PDF document as "22/08/21"
3. if "create google doc" is unchecked, PDF is checked, than the process of generating documents is runnuing endless and generates lots of docs and PDF documents
4. the folder timestamp is not my "GMT+2". e.g folder ...... 2:53 is created and 11:53 is my local time

The biggest problem is not been able to send emails 😒