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

Formula Assistance

Formula checkbox using manual checkbox and lookup formula

Admin Assistance

QrewTip: Formula Logic Order

Combining AND with OR in Formula Checkbox Field