Simple status initial value

[Christopher_Roq]

hi, im a newbie on appsheet, currently im working with my profile information data sheet,

i need some subjection on how to automate may employment status column, with initial value “ACTIVE”,“RESIGNED” status,

example: if the employment end date column is leave blank, the status should be= “ACTIVE”, and if not blank should be "RESIGNED.

I’ve attached screenshot and expression below for reference.

IF(([EMPLOYMENT END DATE] =ISBLANK("")) ,“Resigned”,“Active”)

[LeventK]

@Christopher_Roque
Your expression syntax is not correct

IF(
    ISBLANK([EMPLOYMENT END DATE]),
    "Active",
    "Resigned"
)

[Christopher_Roq]

LeventK:

IF(
    ISBLANK([EMPLOYMENT END DATE]),
    "Active",
    "Resigned"
)

thanks works great

[LeventK]

Excellent, thanks for the feedback. You’re welcome

[Steve]

For reference:

help.appsheet.com

ISBLANK()

Is value absent?