Capacity planning: make advanced estimate values available for equations and filters
For a variety of reasons I would like to be able to perform calculations in custom worksheets on data included in an advanced estimate. For example, being able to reference the totals for a team, and the totals for a given period when a scenario i...
Jeanette Resnikoff
almost 4 years ago
in Worksheets
5
Future consideration
Currently custom date fields used on a record detail view are available for selection on a custom roadmap. However, if date fields are included in a worksheet, those are not available on a custom roadmap. It would be good to include those workshee...
Jeanette Resnikoff
about 4 years ago
in Worksheets
2
Future consideration
I would like to reference to-dos in Custom Worksheet formulas so that I can count the total number of to-dos related to a record. Ideally, I'd like to count the to-dos related to a record based on status (e.g., count of overdue to-dos for this Ini...
Phil Warden
almost 6 years ago
in Worksheets
0
Future consideration
Make worksheet fields work the same as calculated columns
I can use this equation: if (field("fieldname") >= today(), true, false) -- where the field name is a custom date field in an Epic layout, as a calculated column but it won't work as a custom worksheet field equation because have to give the fi...
Robert B
almost 5 years ago
in Worksheets
0
Future consideration
Worksheet - ability to add columns to represent different years
We have initiatives that span multiple multiple years. We use worksheets to calculate the budget for the initiative. Budgets are aligned by fiscal year.
The current problem is Aha does not allow us to add additional budget years as a column. I ...
Guest
over 6 years ago
in Worksheets
2
Future consideration
Allow referencing Notes fields in custom worksheet formulas
I'd like to reference a custom note field in a custom worksheet on an Initiative record to identify if data is missing or incomplete. For example, the assumption is if a custom note field has less than 50 characters, then it's incomplete and requi...
Phil Warden
almost 6 years ago
in Worksheets
1
Future consideration
Allow referencing User-type fields in custom worksheet equations
I'm trying to create a custom equation formula to determine if a user field "Team Members" is empty or not. User fields are currently unsupported in custom worksheets, so I'm not able to build the equation I need.
Phil Warden
almost 5 years ago
in Worksheets
0
Future consideration
Allow worksheets to lookup fields from many/many relationship field
In the same way you are able to reference a property on a custom table via the many/many relationship custom field, it would be great to be able to reference properties on standard record types via the relationship link.
For example, on a featur...
Guest
about 6 years ago
in Worksheets
0
Future consideration