Forum Discussion

SkylarTrivieri's avatar
SkylarTrivieri
Qrew Trainee
8 years ago

show a graph for open vs. closed orders . Need help with formula.

I am trying to show a graph for open vs. closed orders. I currently have the formula correct to show the status is closed. What formula would I use to show the status is open. Right now my graph shows...
EstherGrandal_D's avatar
EstherGrandal_D
Qrew Cadet
8 years ago
In case you do you have a field called [Status Update], it would be a date.

Try this shorter and simple one;

If(IsNull([Engineering Complete Date]),"Open", "Closed")