How can I use a merge field within a formula?
For merge fields that will be referenced by other fields using Excel formulas, we’ve found the easiest way to approach this is to place merge in a non-printing area of the worksheet or on a separate worksheet.
Then, in formulas elsewhere on the spreadsheet, use the cell coordinates to refer to the value.
To use one of these cells in a formula, you would simply refer to the cell reference in the formula. Here, we’re combining the city, state and postal code values with a comma-space after the city field and a space between the state and postal code.
Use =CONCATENATE(…) to join field values together. The abbreviated (“&”) function is not supported.
Exporting Merged Excel as a CVS
To ensure no spaces are carried over to your CVS file output, create an Excel template without spaces between the data being merged. It helps if you surround the merge fields with a table.
How do I set the Printable Area of the Spreadsheet?
You can flag the portion of the spreadsheet you want to print.
To identify the part of the spreadsheet currently specified to print, choose View > Page Break Preview.
To change the printable area:
Select the portion of the spreadsheet that should print using your mouse.
To set the printable area to the selected cells:
Choose File| Print Area > Set Print Area.
On the Page Layout > Print Area, and then click Set Print Area.
Choose View > Normal to return to the previous view mode.
How can I determine which sheets to include in an output PDF?
You can control which sheets are included in an output PDF from a Conga Excel template. To do so, select the sheets you want included by holding the Ctrl key and clicking on each desired sheet.
Excel will highlight the “selected” sheets in white, while the non-selected sheets will remain with a gray background.
In this example, “Sheet1” and “Sheet3” are selected and would be the sheets included in a PDF generated from this template.
What’s the best way to format text paragraphs?
Conga Composer cannot dynamically increase row height to accommodate multiple lines of text. For this reason, it is usually helpful to merge (not mail merge, just merge) a number of rows sufficient to your needs (Format Cells > Alignment Tab > Merge cells) , leaving unmerged rows to the right or left that will preserve the height of the merged area after Salesforce field content is merged.
Here is the formula used in the cell above: