Formula works on Monday.com, but not in General Caster

Platform discussions monday apps & integrations
, ,
1

Hi there,

I’m having issues making a formula work in a General Caster automation (“When column changes, perform formula and cast result to column”) even though it works just fine in Monday.com. I receive an error message whenever General Caster attempts to run the formula. Here’s the formula I’m using - again, it works well in the Monday.com columns, but not in the General Caster.

FORMAT_DATE((WORKDAY({Request Date},{Estimated Business Days})),“MMM DD”)

Thanks in advance for help troubleshooting this!

2

Hi Madeleine,

There is some documentation regarding differences between monday.com and General Caster’s formatting here: General Caster > Documentation

Based on that documentation, I would rewrite your formula as follows:

TEXT((WORKDAY({item's Request Date},{item's Estimated Business Days})),"MMM DD")

Let me know if that works!

3

This worked perfectly, thank you for the help!

1 Like
4

You can achieve it with Autoboost App :slight_smile: