Thanks @rob I have another very important problem right now with General Caster.
We use each board for each projects. we duplicate default board about 10-20 times a day.
Once I duplicate project all apps enabled by default except General Caster, this is very important for us to use this app and could you please let me know how I can make General Caster enable by default like other apps upon duplication of a board. Everytime I duplicate board I had to click “Add to Board”
@Skipper That’s expected. All apps that use OAuth2 process for authentication are not copied with a board.
There are no workaround. That’s the way apps work in monday. Sorry.
Hi Rob,
I added this formula with General Castor to automatically update the email column based on the mirror column. However it is not working. Could you share any tips on how to make it work?
Did you click on the corresponding column button at the bottom of formula field to get the correct column reference?
Keep in my that changes in a mirrored column don’t trigger GC (and any other integrations, that’s how monday works). You need to change a “real” column on purpose.
Hi Rob,
Yeah, I clicked on the mirror column of email in the formula. The trigger is when the status changes to client, then the formula should start working. But it is currently not.
Hi Rob,
Somehow the Email column did not work. It did work after changing the column to a text column.
Thanks for your help.
@MichaelPr Did you check that format of the formula result is correct in order to be accepted by a Email column?
See GC documentation at https://generalcaster.app/website/documentation/formula/#format.
Thanks, that was probably the challenge. However that was not how the mirror column showed it, so transferring to text was the best solution.
Hello,
I’m trying to recreate a Monday formula with General Caster but I can’t figure out what the syntax should be and if it is even possible.
I have a person column with various assignees and I have a number column. The result I want is to multiply to number column with the total amount of assignees in the person’s column. Here’s my Monday formula:
MULTIPLY({People#Count},{Number})
How would I recreate this using a General Caster formula?
Thanks in advance for the tip.
https://generalcaster.app/website/documentation/formula/#syntax
https://generalcaster.app/website/documentation/formula/#differences
https://generalcaster.app/website/documentation/formula/#subitems-and-mirrored-columns
A formula like this should work:
SUBITEMS.COUNT({item's People}) * {item's Number}
@rob
I’m not sure I understand how to use the formula you are suggesting I use. This is the formula I tried to use: SUBITEMS.COUNT({item’s People}) * {item’s Call Duration #} but to no avail.
As you can see in my screenshot what I want is to multiply the Number column (Call Duration #) with the total number of People and cast the result in my total LOE number’s column. So for instance in the first row, the result would be 2.5 → 0.5 X 5 (total count of people assigned).
I guess the question is what is the formula to get a total count for columns with multiple values. The second part is a simple multiply.
Hi @rob I was testing out GC, but hit my limit. This was due to me trying and trying and trying again via trial and error to get my formulas to work. I suspect I should have come here first and not wasted my month’s activity! Here is what I am trying to do: I use GC to total up various estimates we create per department. We enter time spent in the read-only time tracking column. I need to compare the time spent with the total estimates and send a notification when the time spent is greater. When I do this calculation, I get #VALUE because the columns are not in the same format. In order to get the time tracking into the right format, I need to use a formula like: HOUR({task’s Time Spent})+MINUTE({task’s Time Spent})/60+SECOND({task’s Time Spent})/3600
But… it doesn’t return the correct values. Since I ran out of my connections, can you advise and I can try again next month?
Hey @buccit
Please contact us at help@generalcaster.app including addition details on the columns used in the formula and as destination.
Thanks. Just sent it.
I have a mirror column in my subitems that I would like to cast to a text column in subitems. Any way possible to do this?
Casting formula results into subitems is not possible.
Dear Rob;
Would you please help why this formula work in excel but not working with General Caster?
This is the formula in excel that help spell number into word
https://onedrive.live.com/View.aspx?resid=D266F3DAECD76E9D!271089&app=Excel&authkey=!AFhoG5ju3uSpKUM
Here is the formula i use in my monday board
TRIM(IF(OR(LEN(FLOOR({ITEM’S GIÁ TRỊ HỢP ĐỒNG},1))=13,FLOOR({ITEM’S GIÁ TRỊ HỢP ĐỒNG},1)<=0),“Out of range”,PROPER(SUBSTITUTE(CONCATENATE(
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),1,1)+1,“”,“one hundred “,“two hundred “,“three hundred “,“four hundred “,“five hundred “,“six hundred “,“seven hundred “,“eight hundred “,“nine hundred “),
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),2,1)+1,””,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),3,1)+1,“ten”,“eleven”,“twelve”,“thirteen”,“fourteen”,“fifteen”,“sixteen”,“seventeen”,“eighteen”,“nineteen”),“twenty”,“thirty”,“forty”,“fifty”,“sixty”,“seventy”,“eighty”,“ninety”),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),2,1))>1,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),3,1)+1,””,”-one”,”-two”,”-three”,”-four”,”-five”,”-six”,”-seven”,“-eight”,“-nine”),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),2,1))=0,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),3,1)+1,“”,“one”,“two”,“three”,“four”,“five”,“six”,“seven”,“eight”,“nine”),“”)),IF({ITEM’S GIÁ TRỊ HỢP ĐỒNG}>=10^9," billion “,”“),
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),4,1)+1,”“,“one hundred “,“two hundred “,“three hundred “,“four hundred “,“five hundred “,“six hundred “,“seven hundred “,“eight hundred “,“nine hundred “),
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),5,1)+1,””,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),6,1)+1,“ten”,“eleven”,“twelve”,“thirteen”,“fourteen”,“fifteen”,“sixteen”,“seventeen”,“eighteen”,“nineteen”),“twenty”,“thirty”,“forty”,“fifty”,“sixty”,“seventy”,“eighty”,“ninety”),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),5,1))>1,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),6,1)+1,””,”-one”,”-two”,”-three”,”-four”,”-five”,”-six”,”-seven”,”-eight",“-nine”),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),5,1))=0,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),6,1)+1,“”,“one”,“two”,“three”,“four”,“five”,“six”,“seven”,“eight”,“nine”),“”)),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),4,3))>0," million “,”“),
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),7,1)+1,”“,“one hundred “,“two hundred “,“three hundred “,“four hundred “,“five hundred “,“six hundred “,“seven hundred “,“eight hundred “,“nine hundred “),
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),8,1)+1,””,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),9,1)+1,“ten”,“eleven”,“twelve”,“thirteen”,“fourteen”,“fifteen”,“sixteen”,“seventeen”,“eighteen”,“nineteen”),“twenty”,“thirty”,“forty”,“fifty”,“sixty”,“seventy”,“eighty”,“ninety”),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),8,1))>1,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),9,1)+1,””,”-one”,”-two”,”-three”,”-four”,”-five”,”-six”,”-seven”,”-eight",“-nine”),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),8,1))=0,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),9,1)+1,“”,“one”,“two”,“three”,“four”,“five”,“six”,“seven”,“eight”,“nine”),“”)),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),7,3))," thousand “,”“),
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),10,1)+1,”“,“one hundred “,“two hundred “,“three hundred “,“four hundred “,“five hundred “,“six hundred “,“seven hundred “,“eight hundred “,“nine hundred “),
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),11,1)+1,””,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),12,1)+1,“ten”,“eleven”,“twelve”,“thirteen”,“fourteen”,“fifteen”,“sixteen”,“seventeen”,“eighteen”,“nineteen”),“twenty”,“thirty”,“forty”,“fifty”,“sixty”,“seventy”,“eighty”,“ninety”),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),11,1))>1,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),12,1)+1,””,”-one”,”-two”,”-three”,”-four”,”-five”,”-six”,”-seven”,”-eight",“-nine”),IF(VALUE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),11,1))=0,
CHOOSE(MID(TEXT(INT({ITEM’S GIÁ TRỊ HỢP ĐỒNG}),REPT(0,12)),12,1)+1,“”,“one”,“two”,“three”,“four”,“five”,“six”,“seven”,“eight”,“nine”),“”)))," “,” “)&IF(FLOOR({ITEM’S GIÁ TRỊ HỢP ĐỒNG},1)>1,” dollars"," dollar"))&IF(ISERROR(FIND(“.”,{ITEM’S GIÁ TRỊ HỢP ĐỒNG},1))," and No Cents"," and “&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE({ITEM’S GIÁ TRỊ HỢP ĐỒNG},”.“,REPT(” “,255)),255,200)),2))=1,
CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE({ITEM’S GIÁ TRỊ HỢP ĐỒNG},”.“,REPT(” “,255)),255,200)),2),“ten”,“twenty”,“thirty”,“forty”,“fifty”,“sixty”,“seventy”,“eighty”,“ninety”)&” Cents",“”)&CONCATENATE(
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE({ITEM’S GIÁ TRỊ HỢP ĐỒNG},“.”,REPT(" “,255)),255,200)),2)),REPT(0,12)),11,1)+1,”“,
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE({ITEM’S GIÁ TRỊ HỢP ĐỒNG},”.“,REPT(” “,255)),255,200)),2)),REPT(0,12)),12,1)+1,“ten”,“eleven”,“twelve”,“thirteen”,“fourteen”,“fifteen”,“sixteen”,“seventeen”,“eighteen”,“nineteen”)&” Cents",“twenty”,“thirty”,“forty”,“fifty”,“sixty”,“seventy”,“eighty”,“ninety”),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE({ITEM’S GIÁ TRỊ HỢP ĐỒNG},“.”,REPT(" “,255)),255,200)),2)),REPT(0,12)),11,1))>1,
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE({ITEM’S GIÁ TRỊ HỢP ĐỒNG},”.“,REPT(” “,255)),255,200)),2)),REPT(0,12)),12,1)+1,”“,”-one",“-two”,“-three”,“-four”,“-five”,“-six”,“-seven”,“-eight”,“-nine”)&" Cents",IF(LEFT(TRIM(MID(SUBSTITUTE({ITEM’S GIÁ TRỊ HỢP ĐỒNG},“.”,REPT(" “,255)),255,200)),2)=“01”,“one cent”,IF(LEFT(TRIM(MID(SUBSTITUTE({ITEM’S GIÁ TRỊ HỢP ĐỒNG},”.“,REPT(” “,255)),255,200)),1)=“0”,
CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE({ITEM’S GIÁ TRỊ HỢP ĐỒNG},”.“,REPT(” “,255)),255,200)),2)),REPT(0,12)),12,1)+1,”“,“one”,“two”,“three”,“four”,“five”,“six”,“seven”,“eight”,“nine”)&” Cents",“”))))))))
Thanks so much