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”)
@Christopher_Roque
Your expression syntax is not correct
IF(
ISBLANK([EMPLOYMENT END DATE]),
"Active",
"Resigned"
)
thanks works great
Excellent, thanks for the feedback. You’re welcome
For reference:
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |