Updating Field using Field Calculator Python

Question

I am trying to update my Status field as seen below:

I want to change the Null and Existing values to Permanently Removed using the Python Parser; however, I am receiving an error.

Can someone explain what I am doing wrong?

def updateName(sCode):
    if sCode == Null:
       status= 'Permanently Removed'
    elif sCode == 'Existing':
       status = 'Permanently Removed'
    else:
       status = None
    return status

Answer 1

You are so close. As mentioned by @mmore, use "is None" to find Null values. sCode is the variable for Status, therefore use that for the final condition.

See the link on how to use the field calculator.

def updateName(sCode):
    if sCode is None:
        return 'Permanently Removed'
    elif sCode == 'Existing':
        return 'Permanently Removed'
    else:
        return sCode