Color Format Formula
I'm trying to say if the task is overdue by more than 15 days AND it's NOT completed - please highlight the task in the report. Case(true, [Days Overdue]>=15 & [Status]!= "Complete" ,"#FFFFCC",""...
Forum Discussion
You're using & instead of AND. Try this first. If you still get the error, then you need to check the type of field your [Days Overdue] is (which could be a duration). You may need a Days(15) instead of just the number.
Case(true,
[Days Overdue] >=15 AND [Status]<>"Complete","#FFFFCC","")
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
Case(true,
[Days Overdue] >=15 AND [Status]<>"Complete","#FFFFCC","")
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
Thank you. The Days Overdue is a Formula Numeric field.
Neither of those suggestions worked unfortunately.
Case(true,
[Days Overdue]>=15 AND [Status]<> "Complete" ,"#FFFFCC","")
it just says "expecting comma" over the AND so I think we are almost there...
------------------------------
Jack Woods
------------------------------
Neither of those suggestions worked unfortunately.
Case(true,
[Days Overdue]>=15 AND [Status]<> "Complete" ,"#FFFFCC","")
it just says "expecting comma" over the AND so I think we are almost there...
------------------------------
Jack Woods
------------------------------
- MarkShnier__You
Qrew Legend
I am not actually sure what is wrong with that formula but try this version as it is more simple.
IF([Days Overdue]>=15 AND [Status]<> "Complete" ,"#FFFFCC")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- The contents of this e-mail message and
Thank you – Changing it to an IF statement solved my issue.
Have a good one!
any attachments are intended solely for the
addressee(s) and may contain confidential
and/or legally privileged information. If you
are not the intended recipient of this message
or if this message has been addressed to you
in error, please immediately alert the sender
by reply e-mail and then delete this message
and any attachments. If you are not the
intended recipient, you are notified that
any use, dissemination, distribution, copying,
or storage of this message or any attachment
is strictly prohibited.
- Change it to a simple IF statement.
If( [Days Overdue] >=15 and [Status] <> "Complete", "#FFFFCC", "")
I tried your formula in a test scenario and it worked fine; so I am really not sure what is not working on yours.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
