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
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
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
over 1 year 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.
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
10 months 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...
When building calculations using the Worksheet custom field type, it would be helpful to access standard Aha! fields in the calculations. Here are some examples of where standard fields in the worksheet calculations would be helpful:
Lapsed days ...
Madeleine Black
over 7 years ago
in WorksheetsShipped
Auto-refresh for custom worksheets w/ 200+ dependencies
Who would benefit? Customers using custom worksheets with 200+ dependencies in formulas What impact would it make? If a custom worksheet is modified, the auto-refresh to update records does not take place if there are 200+ dependencies within the ...
Brittany Rhoney
over 2 years ago
in WorksheetsShipped