Allow custom worksheet fields to populate without clicking on field in each record
I created a custom worksheet field for my features, and every row in my worksheet contained formulas that were derived from other fields. The formulas in my worksheet only produce values after I manually click on the worksheet field in every recor...
Spencer Abrams
over 6 years ago
in WorksheetsShipped
Support automation triggers and actions for worksheet fields
We have a need to driver some automations based on values in worksheet custom field but Aha! doesn't allow us to select worksheet custom fields while creating automation rules.
Using predefined tags fields in a report calculated field
The ability to use a predefined tag field in a calculated column. For example, if null or if it contains X. You can currently do that via filters however, then your report would exclude records.
Reference capacity planning fields in calculated column equations
Currently the capacity planning fields are not available to use in the Custom Equation builder. It would be great if we could use the fields to perform calculations in list/pivot reports.
An example use case is to calculate the risk of completion ...
Madeleine Black
over 7 years ago
in WorksheetsShipped
Allow votes as a metric for advanced equations in idea scorecards
I want to use multiple metrics in an advanced equation for my idea scorecard. One of these is the number of votes that a given idea has, which would let the score change over time as more or fewer people vote on an idea.
Better equation function to compare against empty notes
What is the challenge? Sometimes you want to check if a note (like descriptions) are empty in an equation field. There are two empty states, one where the note is truly empty, and one where the note is empty after previously having content in it. ...
Jonathan Steel
almost 2 years ago
in WorksheetsShipped
Leverage AI to solve complex Aha! worksheet/calculated column formulas
It would be very helpful if I could describe the calculated column (or worksheet column) that I want in plain english, and have suggested formulas that work with Aha! syntax presented. This would help drive solutions faster and not get caught up i...
Madeleine Black
over 3 years ago
in WorksheetsShipped
Maintain currency format when summing worksheet fields in pivot tables
What is the challenge?
If a pivot table is bringing in currency formatted fields, and "sum values" is selected for the table, then the currency formatting "$" is not included
What is the impact?
The context of this being a currency focused...
Leigh Villalovos
about 1 year ago
in WorksheetsShipped
Add exponent function to custom worksheet functions
What is the challenge? We are capturing the financial business case for new product development projects in a custom table. We use Net Present Value in our financial models, but cannot calculate that with the functions available in the custom work...