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...
DebbieTaylor's avatar
DebbieTaylor
Qrew Trainee
8 years ago
How about 
If(not IsNull([Engineering Complete Date]),"Closed", if([Status Update]="Closed","Closed","Open))