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 -------...
Forum Discussion
Hi Mark,
Thank you for your response. That actually did not return any checkmarks.
Thanks,
Jenna
------------------------------
Jenna Odom
------------------------------
Thank you for your response. That actually did not return any checkmarks.
Thanks,
Jenna
------------------------------
Jenna Odom
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendOk
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
------------------------------
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__YouCan 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
------------------------------- Hi Mark,
I was able to figure it out with this formula:
If (IsNull([Timestamp]), false, true)
Thank you!
Jenna
------------------------------
Jenna Odom
------------------------------- MarkShnier__YouOK, 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
------------------------------