Discussions

 View Only
  • 1.  Checkbox - Formula Assistance

    Posted 01-17-2020 15:57
    Hello,

    I am trying to create a checkbox formula field for "if a timestamp field is blank, checkbox = true" or vise-versa.

    Can someone assist me with this formula?

    Thank you,
    Jenna

    ------------------------------
    Jenna Odom
    ------------------------------


  • 2.  RE: Checkbox - Formula Assistance

    Posted 01-17-2020 16:00
    Not tested but try this

    IsNull([my time stamp field])



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



  • 3.  RE: Checkbox - Formula Assistance

    Posted 01-17-2020 16:08
    Hi Mark,

    Thank you for your response. That actually did not return any checkmarks.

    Thanks,
    Jenna

    ------------------------------
    Jenna Odom
    ------------------------------



  • 4.  RE: Checkbox - Formula Assistance

    Posted 01-17-2020 16:10
    Ok

    i will post back soon then with a different solution.

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



  • 5.  RE: Checkbox - Formula Assistance

    Posted 01-17-2020 16:20
    Can you tell me what field type the field is?  I assumed by a TimeStamp field you meant a date/time field, and that formula should work for that field type.

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



  • 6.  RE: Checkbox - Formula Assistance

    Posted 01-17-2020 16:25
    Hi Mark,

    I was able to figure it out with this formula: 
    If (IsNull([Timestamp]), false, true)

    Thank you!
    Jenna

    ------------------------------
    Jenna Odom
    ------------------------------



  • 7.  RE: Checkbox - Formula Assistance

    Posted 01-17-2020 16:28
    OK, but your question was this :)

    "if a timestamp field is blank, checkbox = true"

    Your formula will do the opposite.  Mine should have answered your question,  but glad that you have it working now the way you want it.

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