Do you guys have any suggestions or alternatives to linking my goal widget to a formula column? I have a formula column summing multiple number columns on my board, but I am unable to select the formula column to my goal widget on my dashboard.
Use the General Caster integration. The General Caster integration can take numbers from Formula columns and project them in Number columns that will make it readable for the Goals Widget to show. To do this, you will need to create a new Number column and then add the General Caster integration to your board.
Once the integration is added, you can select the Formula column that you want to project into the Number column.
The General Caster integration will then automatically update the Number column with the latest values from the Formula column.