Checkbox - Formula Assistance

Question

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------------------------------

markshnier__you · Answer

Not tested but try thisIsNull([my time stamp field])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jennaodom · Answer

Hi Mark,Thank you for your response. That actually did not return any checkmarks.Thanks,Jenna------------------------------Jenna Odom------------------------------

markshnier__you · Answer

Oki will post back soon then with a different solution.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

Can you tell me what field type the field is?&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

jennaodom · Answer

Hi Mark,I was able to figure it out with this formula:&nbsp;If (IsNull([Timestamp]), false, true)Thank you!Jenna------------------------------Jenna Odom------------------------------

Forum Discussion

Checkbox - Formula Assistance

6 Replies

Related Content

Assistance Needed to Locate Formula Fields which include Specific String

Case Formula Assistance

Checkbox Formula - only pertinent records

Checkbox Formula

Formula URL - Edit then Add

Recent Discussions

Question about relationships

Reports & Charts - Managing Client-Specific Name Visibility

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?