OR operator
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 ...
Forum Discussion
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.
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.
it looks like you beat Mark his formula does not work )))
------------------------------
Andrew S
------------------------------
------------------------------
Andrew S
------------------------------
- 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
The or only needs to be in upper case if user as a filter in a report. In a formula the upper lower for the or does not matter.
Andrew, What was the error message when you save?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Give it a try, it surprisingly does have this behavior in both color coding and regular formulas. If you change the or to uppercase it gives an error that says "Expecting ," but it works when lowercase.
