Hello Asana Community.
I want to know if there is a way to incorporate IF THEN ELSE in advanced formula field in Asana. Here is my current setup:
Right now in my formula, if the date of start is before what it is today, it gives me %Complete negative number. So i wanted this formula : IF StartDate=Today then 100 - ( [[$DUE_DATE]] - [[$TODAY]] ) * 100 / ( [[$DUE_DATE]] - [[$STARTED_AT]] ); ELSE (0). But it can not read it
Welcome, @Ilyas_Nurlubayev,
I’m afraid this feature isn’t present in Asana.
I’ve moved this thread to where you can click the title to scroll to the top and vote by clicking the purple Vote button, like I did!
Thanks,
Larry
Thanks Larry! Lets get this voted, really need it )
Push! 
Trying to find a way to run advanced formulas that using if statements.
push
+1 vote for this. Really need IF statements in order to handle negative time values with custom fields.
Hi @Jonathan_W , instead of a formula you may want to try using a rule instead, by leveraging the new number comparison condition which can then populate your number fields, just like a formula (or any other action, as you please)
Note: Not a solution but marked as such to elevate a key reply
So, if/then functions in Asana are limited to fields that compare numbers and dates?
There is no functionality to create if/then statements that can incorporate field types like single-select, multi-select, or text?
Hi @Nick_Crandell , welcome to the forum 
Unfortunately no, this is not currently possible. But you can use Rules that if a single-select / multi-select field is changed, it could change the any number fields, which would in turn affect a formula field (if those numbers were included in that formula).
Yes, this feature is much needed. I need to know what today’s percent allocation is. The rollup feature does not take into account Start date and Due date when calculating percent allocation totals.
As someone who frequently uses advanced Excel formulas, I need to have this functionality available! 
Setting up seven different rules to check if a condition is met feels like a waste of time; at this point, it would be faster for me to enter the information manually. I often spend over two hours each week—if not daily—trying to fix, format, adjust, and create basically everything.
I’ve been using Asana for eight months now, and I’m still struggling to adjust to its limited functionality and personalizations. (My expectations might be too high, though.)
Adding this simple formula setup would make things so much easier! Honestly, it would really improve my experience with the platform and make it way more enjoyable to use!
+1 to this request. Trying to set a Task Age, when not completed, Created on to Today. When completed, Created on to Completion Date.
I have a few complex spreadsheets that I would love to move into Asana but cannot until IF/OR/AND are supported in formulas.
I needed this today, and I realized I was able to hack my way around it with a rule:
I have a dropdown column and a formula. I want to multiply the formula by a different number depending on the value of the dropdown. I can’t do this in the formula editor.
HOWEVER, I can write a rule which sets the value of an extra column whenever the value in the dropdown column changes – and rules DO support if/then/else logic. So I use the rule to set the number that I want in my extra column, and then I use that column’s value in the formula.
This won’t always work depending on the shape of the formula you want, but it will work sometimes.
