Calculated Columns/Fields (Formula Column)
planned
Henri Morse
Custom columns to auto-calculate and hold values of two other "number" columns, meaning that you have formula column adding/Subtracting... two other "number" columns...
Case-in-point: The Favro "Sales CRM" template has a series of columns laid out:
[Deal size] x [Close probability] = [Forecasted Value]... does not auto calculate!, meaning there is no formula calculating [Forecasted Value]
So does that mean that someone has to manually calculate each record?
Dovidas Baranauskas
We do have a workaround for this while we are finishing other features to take on this one.
Workaround: https://favro.canny.io/feature-requests/p/calculated-columnsfields-formula-column
A
Alastair Jarvis
Pleeeeeeaase prioritize this.
S
Simone Nicolini
It would be great to have this feature up and running. When do you think it will be delivered? Thank you Simone Nicolini (Honu - Favro Partner https://www.linkedin.com/company/honu-digital-workplace/mycompany/ )
E
Emil Lamprecht
this would be a huge win for our team, hoping this happens soon!
Dovidas Baranauskas
Merged in a post:
Horizontal Aggregation of numbers in Sheets
August Ejnarsson
I want 3 separate number columns and Sum all of them in a 4:th column in sheet backlog.
Also being able to select which columns would be prefered almost like excel function =SUM(A1+A2+A3)
Joey Naji Kordahi
hey guys - please also add the ability in the formulas for Status to be taken into consideration. So for example [Deal Size] x [Close Probability] & Status: Done = [Completed Value]
Dovidas Baranauskas
Merged in a post:
Formula
P
Paul Lecerf
Make calcul in sheets (like google sheets or excel)
Dovidas Baranauskas
Merged in a post:
Feature prioritization/ ranking
A
Anna Naumova
Add ability to calculate rank based on multiple parameters, which will help to prioritise. For example, on each story I should be able to specify: "Effort", "Risk", "Business Value" and have automatically calculated field "Rank" set by formula (Business Value + Risk)/ Effort
Different companies might have different formulas and it's components to rank the features
Dovidas Baranauskas
Merged in a post:
Ability to create equation/function fields
A
Adam Boyne
This would allow you to add cells together to create a new value. Useful for ratioing values together
Jennifer Batters
Yes! Please
Load More
→