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

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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 blank instead of open. 

This is the formula that I have so far for closed:

If(not IsNull([Engineering Complete Date]),"Closed",[Status Update])
Photo of SkyTriv

SkyTriv

  • 212 Points 100 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Debbie Taylor

Debbie Taylor

  • 604 Points 500 badge 2x thumb
How about 
If(not IsNull([Engineering Complete Date]),"Closed", if([Status Update]="Closed","Closed","Open))
Photo of Esther

Esther

  • 702 Points 500 badge 2x thumb
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")
Photo of SkyTriv

SkyTriv

  • 212 Points 100 badge 2x thumb
Thank you! The shorter version worked!