# Functions Beyond "+, -, *, /" in Custom Field Formulas

I have encountered multiple instances where logic-based calculations would greatly improve the functionality of my custom fields.  One such instance transpired today where I need to calculate the cost of an item based on 2 different methods.  Based on the result of a simple test, I need my calculated field to use method A or method B.  If I could use the absolute value function, then I can accomplish the rest with the basic "+, -, *, /" operators.

The logic is this:

If x > 0, then use method A, else use method B.

This is accomplished by the following:

(x + |x|) / (2 * x) = 1 or (-x + |-x|) / (2 * -x) = 0

Then I can use this result to multiply one part of the equation by 1 while the other is multiplied by 0, giving the final option needed.

Here is my list of desired functions to add:

absolute value "abs()"

if / then / else statements

sin(), cos(), tan(), arcsin(), arccos(), arctan()

Exponential function " ^ " or "exp()"

I'll think of more and add (and would love to hear from others), but I'm sure you've received this request before.

Thank you kindly!

Upvote 10
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
3件のコメント

Thanks a lot for this suggestion Trevor Tollefsbol, I will pass it on to the team shortly 👍

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

I was just about to post a similar thing. Especially using IF, AND, OR statements.

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Another BIG vote for that. Especially needed if new table views are used to build advanced formulas. Please launch this anytime soon!

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Functions Beyond "+, -, *, /" in Custom Field Formulas
[this list is visible for admins and agents only]

トップ