Giving you more power: introducing Excel-style formula attributes
Posted the 12/09/2018 by Jérémy

We are happy to introduce the formula attribute in Kantree. This is a powerful new type of attribute that allows you to compute a value based on other card attributes or properties. This brings a completely new way of retrieving meaningful information from your cards!

Set a formula in your cards.

As any other attributes, formula should be added to the structure of your cards or to a card model. To create a query for your formula attribute, you should master our internal query language (Learn everything you should know about it in our guide). There isn’t any autocomplete feature available yet but we will add it soon.

Here we’re setting up a Total Cost attribute based on our Price and Quantity. Set formula attribute

Now, Total Cost computation will be automatically done for all cards that have acces to this attribute! Formula attribute cost example

Formula attributes can be used in other formula attributes or in project reports. You can then further automate your projects.

Using Formulas

For the moment, formula attributes are best used in combination with other number attributes, like in our example above. However we do already extensively support all the features of our query language! This could help you:

  • compute Eisenhower priority based on the urgency and importance of your tasks. Formula attribute eisenhower example
  • count remaining days before due date Formula attribute date example
  • generate the expected revenue of a sale negociation based on the probability of closing the deal Formula attribute sales example
  • and much more!

We are excited to see which awesome things you will do with this new formula attribute.

Feel free to give us feedback by email or on twitter @kantreeapp. We will continue to expand the possibilities of our query language to handle more and more use cases.

Stay tuned for more new features to come!


Try 30 days for free

Kantree is the all-in-one collaboration and work management platform that help teams across the whole company work better together.

Start your 30 days free trial now!

Follow us on Twitter Follow us on LinkedIn