General Caster is here. Get rid of formula columns!

@rob
Results:

1. #value! when i use ENCODEURL({item’s Nombre completo mentor})
2. A6 when i use ENCODEURL("{item’s Nombre completo mentor}")

@elena
You don’t need to wrap the column reference between the double quotes, so the first version is correct.

ENCODEURL({item’s Nombre completo mentor})

ENCODEURL function requires a string as parameter, so I guess the raw value you pass is not accepted.
Just force the value to passed as string with one of the following options:

ENCODEURL(CONCATENATE("", {item’s Nombre completo mentor}))

or

ENCODEURL(TEXT({item’s Nombre completo mentor}, "0"))

@rob We want to be able to sort data from the timetracker data log, so that we can pull time logged this month, last november etc.

Is that something you can do with General Caster?

Hey @AdamCPU
Please explain your request.
General Cast can already retrieve summary data from a Time Tracking column, but logs are not supported at the moment.

Hey @rob

I need to change a progress column based on a status column change. I currently have a mirrored column providing me with a value I need presented as the status column to drive the progress column.

I was wondering if there is any way General Caster can help?

As per monday.com documentation, Progress column cannot be updated by General Caster (and any other app).

Hey @rob I need to push 2 days of “Target Finish Date” column if “target finish date” falls weekend.

For example if Today is 26th January , 2022 (wednesday) and Dead Line Days(number) is 4, the result is in “Target Finish Date” Column should be 1 February (Tuesday) 2022 and NOT 30 January (Sunday) 2022, pushing 2 days further because we don’t work on the weekends.

I tried this formula “RIGHT(LEFT(CONCATENATE(WORKDAY({Start Date}, ({Deadline Days}))), 15), 11)” IT works great couldn’t convert this function to general caster
Or this formula also doesn’t work on general caster WORKDAY({item’s Start Date}, {item’s Deadline Days})

Some how Target Finish Date(Date) returns “1 Jan, 1970” no matter what the “Start Date” is and not 1 February 2022

When I do debug with the Text it returns number like “44594” “44584” etc. I am thinking format issues but could you tell me where I am going to add days format so date column would understand as a date.

Found it !
TEXT(WORKDAY(DATEVALUE({item’s Start Date}), {item’s Deadline Days}), “YYYY-MM-DD”)

Glad to know the formula works.
Yes, after your calculations, you need to convert a date value into the correct format in order to be accepted by a Date column.
There’s a section about it in GC documentation at https://generalcaster.app/website/documentation/formula/#date.

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.

@rob I see is there anyway around this ? some other automation settings,app, etc. ?

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?

@MichaelPr

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.