Worksheets

What is the challenge? I need to use historical data to develop trend reporting for upcoming FY and quarters. What is the impact? Without this data it is difficult to build budgets and make decisions on products and offerings in the next 1...

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...

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...

Who would benefit? Everyone tracking OKRs in Aha! Roadmaps What impact would it make? Allow teams to leverage the power of worksheets to perform custom calculations on their key result data How should it work? Support referencing key results in wo...

What is the challenge? I cannot customize a worksheet field in order to display a color based on calculation results What is the impact? My reports display text vs color for my RAG status results Describe your idea I want to customiz...

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...

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...

Who would benefit? product owners/managers, program managers, project managers What impact would it make? While dependency reports are very valuable, it would be helpful to be able to pull in depends on record fields into the record with the depen...

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...

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.