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
------------------------------- 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
------------------------------
