Trouble Using Custom Formula Values in Dashboards

[Stephen Newman]

I am using PD Custom Formula to calculate numerical values. Let's call it "Hours" based on T-shirt Sizing.  I can write the custom formula and generate numerical values for "Hours" in PD and add a column for that customer formula and see the resulting "Hours".  I can sort them in ascending or descending order.  Everything is great.



However, when I build a dashboard (i've tried numerous different apps), it doesn't seem to recognize the value of the customer formula for "Hours".   If I create another field that is of type number and type in the number for hours - then I can get the dashboard to work, but when I ask the dashboard to use the values from the custom formula output - it isn't able to pull the values.  

This shows the same dashboard widget. The left is trying to pull the values from the Custom Formula "Hours" and the right is pulling the values from a numeric field I named "Hrs" and just typed in integers for each row.  

Is there ANY way around this?  Typing in the hours is not what we want to do.

Thanks - Stephen

[Tanguy Crusson · Accepted solution]

Hi @Stephen Newman that's a current limitation of the product: formulas are only calculated client-side and not saved in the backend - so they are not available for dashboards, JQL, automation rules, etc. 

We'll fix this, but it's not going to be in the short term