Mirror columns that combine multiple items

Mirror columns that combine multiple items will display as a comma-separated list in your document.. If your Connect Boards Column is pointing to multiple items (on one or multiple source boards), monday.com allows you to display an aggregate value (sum, average, etc.) on the Mirror Column. For example, if the selected items are $10, $12, and $17, monday.com can just display $13 in the Mirror Column (the average of the three numbers.) However, if you generate a document containing the Mirror Column, DocuGen will show the content of the column as a list of values separated by commas, in this example "10, 12, 17".

Unfortunately there is currently no workaround for this limitation, but we're working on fixing it in a future release.

Mirror columns that are used in formulas and summaries

If your subitems contain a formula column that references a mirror column, and the corresponding connect-board column is blank, any summary column at the main item level will be blank when the document is generated. Keep reading for the workaround.

Imagine your subitems contain the following columns:

• Connect-board column where some values are blank
• Mirror column
• Formula column using the mirror column

And imagine you have a summary column on the main item summarizing the subitems formula column.

Here is an example:

And this is the generated document:

Notice that the values of the subitem columns and the value of the summary column display correctly in the generated document (even if some mirror values are blank) **except** if the connect-board column is blank (the last row above.) When the connect-board column is blank, formula columns that depend on the corresponding mirror columns will be blank in the generated document. This applies whether you insert the values as a table or as an in-line placeholder.

Workaround

You will need to modify the subitem formula column with an IF() function to address the situation where the connect-board column is blank. For example, instead of:

ROUND({Some blanks}*{Price mirror}, 2)

... use this:

ROUND({Some blanks}*IF({Connect board}="",0,{Price mirror}), 2)

The IF() part takes care of replacing the blank mirror with a zero if the connect-board column is empty.