Forum Discussion

RyanWhitener's avatar
RyanWhitener
Qrew Cadet
4 years ago

Formula Checkbox based on User Field Present

I am trying to write a formula checkbox formula that would be checked when a user field has a user listed.  I tried a couple different formulas but couldn't get it to work. I think I am missing something....

[Employee-Previous Supervisor] is my user field

1st try- Case([Employee - Previous Supervisor],null,false,true)

2nd try- If([Employee - Previous Supervisor]<>null,false,true)


What am I missing. Do I need to covert my user field to something else?

Thanks,

------------------------------
Ryan Whitener
------------------------------
Formulas and functions

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    If you are looking to check if the user field [Employee - Previous Supervisor] is not blank, then this should be true If the User field is not empty.

    not IsNull([Employee - Previous Supervisor])

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------