Calculated formula data cannot be displayed on Goal Widgets

Hi there,

I´ve seen that I can only track goals from number columns. Is there a workarround to display calculated formula data?

I.E., for each project I calculate the gross margin. At the end of the month, I would love to know what is the gross margin sum of all done projects vs my goal (fixed costs). This helps me to understand if I am bellow or above my “floating line”.

I am actually using the number widget, sum option of gross margin column, filtering by done project. It is OK, but as you developed the goal widget, this could improve it a lot.

Many thanks

Yeh need to add this as most totals end up being formulas rather than numbers columns. You want your totals used towards a goal so this widget would improve tenfold by adding formula columns.

Hi @Jack and @egronberger !

There is a native integration with called General Caster that can take numbers from Formula columns and project them in Number columns that will make it readable for the Goals Widget to show!

Let me know if you have questions about this!

Hope it helped!

Hi, I would like to know more about use formula columns in goal widget, Thanks