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!
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
I was just about to post a similar thing. Especially using IF, AND, OR statements.
Another BIG vote for that. Especially needed if new table views are used to build advanced formulas. Please launch this anytime soon!
Hi 👋 Scott McKinley, thanks for the suggestion, and Michael Pucher, thank you for the BIG vote! I've forwarded both of your comments to our Product Team. I'll make sure to keep you updated if there's any progress on this suggestion in the future. 👍
Rohan V Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Rohan V Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Rohan V Thanks! Could you and/or the dev team also keep in mind, that other tools offer advanced calculations, even e.g. with if/then ... like e.g. Notion.
Even a simple IF statement would be valuable, as we track projects by planned finish date in one column and quarter/year in the next. Since this is manually entered folks seem unable to calculate months to quarters..I know it is a people issue but in my 7 years here it continually requires data sanitization. I would suggest that if IF was incorporated into a formula field then we could automate the task of quarter and year very easily. (Planned Finish Date 03/03/24 could easily show Q1 2024 in the next column). Any plans for this simple request?
Basudha Sakshyarika Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Basudha Sakshyarika Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Hi,
would like to follow up on this, while I was trying to create "Excel like" equation, I found this conversation, was it updated by any way that we have equations like "IF - Count If - Vlookup - Date ... etc) in Wrike now ?
The formula does not only need a few more functions, but it needs a huge improvement. I come from using another project management software on my previous company, and I was able to use several formulas that we find in MS Excel. I'm feeling very much limited within Wrike at what I used to do before.
Hi Samer Abdelshahid and Henry Seron! 🙋🏻♀️ Thank you for checking in and sharing your feedback. At the moment there's no new update related to this that I can share. We will keep you posted on any developments. Thank you! 😊
Basudha Sakshyarika Community Team at Wrike Wrike Product Manager En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Basudha Sakshyarika Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online