Discussions

Expand all | Collapse all

Formula Checkbox based on User Field Present

  • 1.  Formula Checkbox based on User Field Present

    Posted 10 days ago
    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
    ------------------------------


  • 2.  RE: Formula Checkbox based on User Field Present

    Posted 10 days 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
    ------------------------------