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
Calculated Column Formula
Evo Administrator
04-03-2018 14:49
I have a text field that I am trying to sort by if it has text in it or not. Current formula is: If([Notes]="", ...
Jim Harrison
04-03-2018 15:30
Your If statement requires the test, the true and the false. Your test is [Notes]="" - means if the ...
Evo Administrator
04-03-2018 15:32
Thank you!!
1.
Calculated Column Formula
1
Like
Evo Administrator
Posted 04-03-2018 14:49
Reply
Reply Privately
Options Dropdown
I have a text field that I am trying to sort by if it has text in it or not.
Current formula is:
If([Notes]="", "Needs Action")
What do I need to add to have it call the group of notes with text in the field "Addressed
2.
RE: Calculated Column Formula
0
Like
Jim Harrison
Posted 04-03-2018 15:30
Reply
Reply Privately
Options Dropdown
Your If statement requires the test, the true and the false. Your test is [Notes]="" - means if the notes fields is blank. The next bit is the true part. IF(Notes]="", "Needs Action", "Addressed) - this says If notes is blank, then needs action else addressed.
3.
RE: Calculated Column Formula
0
Like
Evo Administrator
Posted 04-03-2018 15:32
Reply
Reply Privately
Options Dropdown
Thank you!!
×
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