I am trying to cast existing formula in a number column, but it doesn’t work.
The formula is using IF function.
The formatting and language is slightly different than Monday formulas. Can you share your formula or an example?
You could also try the other General Caster integration “perform formula and cast to column” instead of the existing formula one.
Thanks for responding
It is as follows:
({Amount}-{Pay.1}-{Pay.2}-{Pay.3}-{Pay.4}-{Pay.5})/{Amount}%
I tired both integrations, but had no luck
What I want to do is casting a percentage in a number result, so I can use status and automation, as on automation doesn’t recognize the result number in a formula column, so I thought casting the result into a number column will help me to do what I need.
I never use the “perform existing formula” integration simply because I don’t like the trigger “when any column changes”. I find that it is slower to trigger and not as reliable as “when status changes”. But I understand if you need to use that in your workflow.
I tested a formula similar to yours and the culprit is the “%” at the end of your formula. General Caster isn’t recognizing it even when performing an existing formula. Can you adjust your formula in Monday so that you get the same number result, without using the “%”? If not, you might want to look into General Casters formatting and figure out how to do it there. This link shows the functions that they support: Functions | Formula.js.
Keep in mind, if you are going to build the formula in General Caster, you will need to change you the bracketed column names to match GC’s formatting as well. You can’t just copy and paste from the Monday formula column to General Caster.
Hope this helps!
1 Like
Hi @rob! This looks amazing…although I’m currently having trouble installing and running the integration. I am able to install the app and set up the integration but nothing happens (I’ve tried both the “any columns” flavor and “when status changes” flavor - both attempting to cast to a Text column. I’ve tried to make the formula just the name of the item for testing purposes and no luck. Any suggestions?
@adrian1 Please contact us at info@omnidea.it attaching your:
- User ID
- Account ID
- Account URL
good afternoon, i am trying do it with a mirror column to get it that information to a number column, if it is possible do that?, also i created a column of formula with the information of the mirror column but and when i did the integration with general caster in the number column get a 0 and not the number that i have in the mirror column. i need help please, thanks.
The new version of General Caster that will be released in a couple of days will support mirror columns.
1 Like
Do you have any recipes that would only cast a formula result when an item is created rather than when any column changes?
Also if I am casting the formula result to a date column, Is there any way in the formula to make sure the time doesn’t show up in the date column?
Yes, item creation trigger will be supported.
The new version fixes it.
Please DM me to get an installation link.
Thanks Rob
I’ve sent a DM to you 
I’ve just noticed that the app seems to have been updated but the ‘perform existing formula’ options has gone?
Is there a chance you can create an automation for ‘when status changes perform existing forumla and cast result to column’?
The new and improved General Caster version is available here:
At the moment the “perform existing formula” integration is not available.
Any idea when the ‘perform existing formula’ integration will be available again?
It has become an integral part of our workflow.
I agree! The existing formula is really important for us. Unless you can perform the same formula directly in Caster?
Hey @opgoodmanors
“Perform existing formula” has been removed because now we are using a more powerful engine to calculate results and the syntax is slightly different from the one used in the Formula column.
The syntax is now the same of Microsoft Excel (not Excel-like as previously).
We are going to release new documentation soon.
Hey @WTagreen
I confirm you can perform the same formula in General Caster, with few changes as said.
Examples:
The old
ADD_DAYS({item.date}, 10)
is now a much simpler
{item.date} + 10
The old
DATE_FORMAT({item.date}, "YYYY-MM-DD")
is now
TEXT({item.date}, "yyyy-mm-dd")
Just as in Microsoft Excel.
3 Likes
Update I’ve managed to make this work using the column ID instead
Are you able to help me transfer this formula into something that will work in Caster?
IF({Job Size}=“Extra Small”,2,IF({Job Size}=“Small”,5,IF({Job Size}=“Medium”,12,IF({Job Size}=“Large”,30,IF({Job Size}=“Extra Large”,70,"<-- Enter Job Size")))))
Thanks
Hello, the new application does not work properly.
I’m trying to calculate a new date (except weekends).
Please see at the pictures. Can you help me?
Thanks
Hey @Jiri
General Caster recently migrated to a new more powerful and faster platform.
The PROS are that now more integrations have been published (and more are to come) and formulas use the Excel official syntax (not a Excel-like syntax as previously).
The CONS are that “performing existing formula” integration is now gone due to small differences in the syntax used in the Formula column and in General Caster and some of your formulas must be updated.
We are going to publish a complete documentation. In the meantime, you can take a look at
In order to check what’s wrong with your formula, please check what the result actually is by casting it into a temporary Text column and change it accordingly.
You should be able to use TEXT(WORKDAY({item.date4} + {item.numbers}), “yyyy-mm-dd”) to get the correct format.
2 Likes