DocuGen offers partial support for

**Formula**columns. Please bear in mind the following considerations when using Formula columns with DocuGen.## Unsupported Functions

The following monday.com functions are not supported:

Function |
Example |
Workaround |

TEXT() |
TEXT({Amount}+({Amount}*0.14975),"$#,##0.00") Sample result: $5,678.32 |
ROUND(100*({Amount}+({Amount}*0.14975)),0)/100 Will give the same result |

ADD_DAYS() |
ADD_DAYS("2019-01-20", 5) Result: "2019-01-25" |
Use General Caster to copy the result of the formula into a Date column, and use the Date column in your DocuGen document |

FORMAT_DATE() |
FORMAT_DATE(TODAY(), "YYYY-MM-DD") Sample result: "2020-02-16" |
Check how to format dates here |

HOURS_DIFF() |
HOURS_DIFF("23:00", "20:00") Result: 03:00 |
Use General Caster to copy the result of the formula into a Text column, and use the Text column in your DocuGen document |

WORKDAYS() |
WORKDAYS({TO_DATE}, {FROM_DATE}) | Use General Caster to copy the result of the formula into a Numbers column, and use the Numbers column in your DocuGen document |

SUBTRACT_DAYS() |
SUBTRACT_DAYS("2019-01-20", 5) Result: "2019-01-15" |
Use General Caster to copy the result of the formula into a Date column, and use the Date column in your DocuGen document |

Nested Formulas

Formulas should not be nested, meaning that the formula should not refer to a column that is also a formula. The workaround is to include the full formula in the column.

Nested formula(not supported by DocuGen) |
Equivalent formula without nesting (supported by DocuGen) |

Total Price = Amount * (1 - Discount) Amount = Quantity * Price Notice that "Amount" is a formula (Quantity * Price) that is used inside another formula (Total Price). |
Total Price = (Quantity * Price) * (1 - Discount) This formula will give exactly the same result as the nested formula on the left. |

## Comments

0 comments

Please sign in to leave a comment.