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).
