Adding a new Column with Logic

[niharika1234]

Hello,

I have a Column name 

The Column is VLD_STAR_INCIDENT_ID. I want to see the column like below. When VLD_STAR_INCIDENT_ID = 10000, it is Open  and if   VLD_STAR_INCIDENT_ID = 10001 , it is Closed. So the Final column should come like :

Stat_Incident:

closed

Open

closed

open 

closed 

....

Please suggest

[lblumenfeld · Accepted solution]

Are you saying that if VLD_STAR_INCIDENT_ID = 10000 then show "Open" or if VLD_STAR_INCIDENT_ID = 10001 then show "Closed"?

If so then

=If(VLD_STAR_INCIDENT_ID = 10000, 'Open', If(VLD_STAR_INCIDENT_ID = 10001, 'Closed'))

Should work.