Forum Discussion

JennaOdom's avatar
JennaOdom
Qrew Member
5 years ago

Checkbox - Formula Assistance

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 -------...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
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
------------------------------
JennaOdom's avatar
JennaOdom
Qrew Member
5 years ago
Hi Mark,

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

Thanks,
Jenna

------------------------------
Jenna Odom
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew Champion
      5 years ago
      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
      ------------------------------
      • JennaOdom's avatar
        JennaOdom
        Qrew Member
        5 years ago
        Hi Mark,

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

        Thank you!
        Jenna

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