Variance on time or behind schedule collumn

Joechaptaylor

hi,

can anyone help me create a column that tracks if my variance column is above or equal to 0 then return a value of “on track” if the value is below 0 then return “behind schedule” BUT return a blank value if the variance column is blank.

Philip Robbins

Hello @Joechaptaylor. Try something like:
=if(Variance@row="","",if(Variance@row>=0,"On Track","Behind Schedule"))

Joechaptaylor

Perfect - This does exactly as asked.

Apologies for not including this in my original request, I had an oversight to not include anywhere whereby the column "status" @row = "Blocked/HOLD".

I tried adding an additional IF command, but this doesn't work - assume I'm missing something simple?