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 |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |