Skip to main content
Conga Support

Special Excel Merge Fields

Conga Composer offers several additional merge fields for even more flexibility in your merge templates.

Today’s Date (Text)

Create a &=Date.Today merge field to insert a Date field and insert the current date as a text string.

You cannot apply a date-format to this value because it is a text string.

Today’s Date (numeric)

Create a &=Date.Today(numeric) merge field to insert the current date and apply Excel cell formatting.

Today’s Date (Date/Time Value)

Create a &=Date.TodayDT merge field to insert the current date as a date/time value. You can format the resulting date with any of Excel’s date-formatting options.

Hyperlinks in Excel

Conga cannot create hyperlinks in Excel. You can use Excel link a merged Conga field. Merge the URL into the first column. Then use a hyperlink formula in the next column, for example: &=&=HYPERLINK(A{r}, "Click Here". Optionally, you can hide Column A so only "Click Here" in Column B is visible to the end user.

Percentage Fields

Percentage fields in Excel are not actually a percent in Salesforce. You must apply an Excel formula to your output. A best practice is to create two columns: one for the merge field and another for the calculation. After testing, hide the merge field cell.

&=Opportunity.Probability_%(numeric) &=&=C{r}/100

Row Number Field

The ROW_NUMBER field numbers each line item in a detail dataset and is included by default in every report or query dataset.  Insert this field into any detail region in the template to number the results in the merged output file. 

When the {{ROW_NUMBER}} merge field is placed in the far left column:

The merged output file looks like this: