Copy output of function to a column?

Platform discussions Special workflows & use cases
, , ,
1

Hey all,
Is there a way to take a number thats generated from a formula column and copy it into a number column?

I’ve looked at Column Magic and Autoboost but they don’t recognise formula columns at the moment :frowning:

Thanks
Drew

2

Hi @johnners - check out General Caster, you can then utilize cast the formula within the app to the column of your choice.

Hope this helps,
Mark

3

Hey! Can you let me know what the “formula” is when I use "When column changes perform (“formula”) and cast result to column.

I have a formula column called “# of days” and I want it to reflect to a numbers column using general caster.

4

Hi @Mindflows_Shanine - are you looking for the number of days between two dates? If so, in general caster you can use the following formula:

image
image963×187 15.7 KB

DAYS({item's End Date},{item's Start Date})

You would need to setup two recipes with General Caster, one to monitor Start Date and one to monitor End Date for changes:

image
image1018×252 20.7 KB

Hope this helps!
Mark

5

Hi Mark!

Thank you for your response. I did the formula as you have shown but I got an error.

Here’s the board

board1
board11186×618 35.8 KB

Here’s the automation I set up with General Caster

formula_gc
formula_gc1230×550 45.4 KB

Here’s the error I received

error_notif
error_notif1158×514 54.7 KB

Hoping for feedback! Thank you so much.

6

Hi @Mindflows_Shanine - you need to use DAYS() not DATE(). This is why you are getting the error.

7

Hey! You can use Column to Column app to copy the value from formula column to another standard column (text, number, date, …).

image
image588×454 37.9 KB

With this app you can select the actual formula column in the recipe.

Pricing is based solely on the number of seats, the usage is unlimited.