Hello,I have a formula for color coding:Case([BUDGET LINES CREATED],false,"#000000") & Case([BUDGET UPDATED],false,"#000000")How can I use OR operator instead of AND ($)tried | - does not work.------------------------------Andrew S------------------------------

Is that your full color coding formula? If so I don't see the reason for using case here.if([BUDGET LINES CREATED] = false or [BUDGET UPDATED] = false,"#000000")This should do it I think. Not sure if that needs quotes or not up there but I left it as you had it.Edit: Of course I take a little longer and mark beats me to it lol.

try thisIF(not [BUDGET LINES CREATED] OR not [BUDGET UPDATED], "#000000")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

don't work------------------------------Andrew S------------------------------

Andrew, can you post he error message when you save the formula? can you tell me what field type the two fields are?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

it looks like you beat Mark his formula does not work )))------------------------------Andrew S------------------------------

OR operator | Qrew Discussions

11 Replies

AustinK
Qrew Commander
4 years ago
Is that your full color coding formula? If so I don't see the reason for using case here.

if(
[BUDGET LINES CREATED] = false or [BUDGET UPDATED] = false,"#000000"
)

This should do it I think. Not sure if that needs quotes or not up there but I left it as you had it.

Edit: Of course I take a little longer and mark beats me to it lol.
- AndrewS
  Qrew Trainee
  4 years ago
  it looks like you beat Mark his formula does not work )))
  
  ------------------------------
  Andrew S
  ------------------------------
  - AustinK
    Qrew Commander
    4 years ago
    I believe the error in the other formula is the uppercase OR, it needs to be lowercase. Something that has frustrated me many times in the past.
MarkShnier__You
Qrew Legend
4 years ago
try this
IF(
not [BUDGET LINES CREATED]
OR
not [BUDGET UPDATED], "#000000")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- AndrewS
  Qrew Trainee
  4 years ago
  don't work
  
  ------------------------------
  Andrew S
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    4 years ago
    Andrew, can you post he error message when you save the formula? can you tell me what field type the two fields are?
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

OR operator