Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
Not IsNull
BuildPro
09-20-2019 13:35
If date field is not empty, return "COMPLETED" in text field. If [Sub Payroll - Actual Finish Date] ...
Mark Shnier (Your Quickbase Coach)
09-20-2019 13:41
Try this IF(not IsNull([ [Sub Payroll - Actual Finish Date]), "COMPLETED") **** typo corrected above ...
Austin K
09-20-2019 15:32
If(not IsNull([Sub Payroll - Actual Finish Date]), "COMPLETED") There were some extra characters and ...
Giuseppe Macri
09-20-2019 15:41
Dates are friggin weird in QB and nulls. try: If(ToText( [Sub Payroll - Actual Finish Date])=null, ...
1.
Not IsNull
0
Like
BuildPro
Posted 09-20-2019 13:35
Reply
Reply Privately
Options Dropdown
If date field is not empty, return "COMPLETED" in text field.
If [Sub Payroll - Actual Finish Date] is empty
[Status Completed]=COMPLETED
------------------------------
Lynne8817 Lynne8817
------------------------------
2.
RE: Not IsNull
0
Like
Mark Shnier (Your Quickbase Coach)
Posted 09-20-2019 13:41
Edited by Mark Shnier (Your Quickbase Coach) 09-20-2019 15:57
Reply
Reply Privately
Options Dropdown
Try this
IF(not IsNull([
[Sub Payroll - Actual Finish Date]), "COMPLETED")
**** typo corrected above ****
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Original Message
Original Message:
Sent: 09-20-2019 13:35
From: Lynne8817 Lynne8817
Subject: Not IsNull
If date field is not empty, return "COMPLETED" in text field.
If [Sub Payroll - Actual Finish Date] is empty
[Status Completed]=COMPLETED
------------------------------
Lynne8817 Lynne8817
------------------------------
3.
RE: Not IsNull
0
Like
Austin K
Posted 09-20-2019 15:32
Reply
Reply Privately
Options Dropdown
If(not IsNull([Sub Payroll - Actual Finish Date]), "COMPLETED")
There were some extra characters and one of the parenthesis was not closed. Just figured since the poster was so lost on this formula initially they may not know how to fix that too.
Original Message
Original Message:
Sent: 09-20-2019 13:40
From: Mark Shnier (YQC)
Subject: Not IsNull
Try this
IF(not IsNull([
[Sub Payroll - Actual Finish Date]],, "COMPLETED")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
Original Message:
Sent: 09-20-2019 13:35
From: Lynne8817 Lynne8817
Subject: Not IsNull
If date field is not empty, return "COMPLETED" in text field.
If [Sub Payroll - Actual Finish Date] is empty
[Status Completed]=COMPLETED
------------------------------
Lynne8817 Lynne8817
------------------------------
4.
RE: Not IsNull
0
Like
Giuseppe Macri
Posted 09-20-2019 15:41
Edited by Giuseppe Macri 09-20-2019 15:42
Reply
Reply Privately
Options Dropdown
Dates are friggin weird in QB and nulls.
try:
If(ToText(
[Sub Payroll - Actual Finish Date])=null, //Some Status Field,"Completed")
You don't need a status field for the true condition but it may be better to add text so you know to review that record.
Ideally, this sounds like a Formula-Checkbox rather than Formula-Text. Maybe better to just use that and change the string to just TRUE for easier filtering
------------------------------
G.Macri G.Macri
------------------------------
Original Message
Original Message:
Sent: 09-20-2019 13:35
From: Lynne8817 Lynne8817
Subject: Not IsNull
If date field is not empty, return "COMPLETED" in text field.
If [Sub Payroll - Actual Finish Date] is empty
[Status Completed]=COMPLETED
------------------------------
Lynne8817 Lynne8817
------------------------------
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic