Formula Custom Fields (calculated, computed, or formula fields)
complete
E
Eric Typaldos
Often times it's valuable to have excel-style calculations or formulae based on other fields already set in Hive.
For example, if regularly had to run ad-hoc analysis on actions based on time spent multiplied by a custom field on each respective action, I would have to export it to CSV or Excel and manually add a formula.
If Hive had a new custom field type for Formula where I could define basic operations (math operations, referencing other fields, hard-coding values, etc.) then I could avoid the extra step and save a lot of time + effort.
Ideally, having this in Table Layout to start would be most useful and then adding support in new places from there.
Log In
CJ Jordan
complete
CJ Jordan
in progress
K
Kris Faulkner
CJ Jordan: Pretty excited about this actually.
CJ Jordan
planned
CJ Jordan
Marking this as possibly related and to be reviewed in parallel - https://hiveteams.canny.io/feature-requests/p/ability-to-calculate-percent-complete-of-an-action For now, we are not merging the requests.
CJ Jordan
under review
We're pulling this forward and will be looking to do our first release support this in the near future. We're likely to have some follow up requests after that, so keep these coming!
K
Kris Faulkner
This would be amazing and really set Hive apart.
E
Eric Typaldos
Lisa Sanders just a heads up, I know your team was looking to be able to easily track how long something takes from ticket submission (Action created at date) to ticket completion (Action completed at date). This could totally solve that, so I've added you assuming that is something your team still cares about.
E
Eric Typaldos
Merged in a post:
Math Functions and Formulas
L
Lauren DeBell
Our team heavily relies on basic math functions to help summarize progress. Even basic functions like selecting a group of actions in table view and being able to sum them. Actions like trying to track the number of new housing units coming online would be essential - the only way to do this currently is to export as a .csv, enable editing and change the formatting, then use the functions in Excel - this is a very time consuming workaround so it would be great if Hive had some built in functions. Thanks
E
Eric Typaldos
Merged in a post:
Adding Formulas to Hive
J
Josh Fuller
My team is very used to the world of excel. We have a lot of worksheets that do simple math to get margin % or build complexity scores, or even to just sum up our expenses for the year. It would be amazing if we could track some of these details in Hive, and get totals for fields, build simple addition or multiplication formulas into custom fields, or generally reduce the need for a calculator when entering data.