Smartsheet Merge for Google Docs

Karen Sabourin

Has anyone successfully used conditional formatting (i.e. if/then statemnets) within smartsheet merge to google docs?

JohnHinkle

What do you mean by this? What are you trying to accomplish / what is your use case for this?

 

conditional formatting is used to apply formatting to cells in your sheet. Are you trying to get the formatting added to the Google Doc?

Karen Sabourin

I understand how this was confusing.  

 

We would like to have multiple rows summarized into one page of a gogole doc.  In typical systems you can say something like {{next record"}}.  This was it does not move to the next page of the document with each new row.  Is this possible?

 

And as a second part we would also love to say if the item has a certain criteria to move onto the next entry.  These are all items that can be done with a standard word processing mail merge.

Joseph Miller

Hello Karen,

 

Unfortunately at this time conditional formatting (logical formatting) is not supported using the Google Merge addon. 

 

I will pass this information over to the product team though to see if it's viable for a future release.

 

Cheers,

Joseph

Monica Evanchik

Hi,

 

I've just started using Smartsheet Merge for exporting data into a Creative Brief form. 

 

Here's my question: When a checkbox is checked in a Smartsheet column, can Merge be used to display the checkbox?

 

Right now, I only see the boolean displayed. It reads the word "true."

 

Any help on this issue would be appreciated.

 

Thank you, Monica Evanchik