Getting Started

 View Only
  • 1.  Color Format Formula

    Posted 03-23-2021 09:57
    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","")

    it seems to be giving me the error of...

    "the operator ">=" can't be applied to types number, text"

    please advise :)

    ------------------------------
    Jack Woods
    ------------------------------


  • 2.  RE: Color Format Formula

    Posted 03-23-2021 10:21
    Edited by Laura Thacker 03-23-2021 10:22
    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
    ------------------------------



  • 3.  RE: Color Format Formula

    Posted 03-23-2021 11:49
    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
    ------------------------------



  • 4.  RE: Color Format Formula

    Posted 03-23-2021 11:55
    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
    ------------------------------



  • 5.  RE: Color Format Formula

    Posted 03-23-2021 14:12

    Thank you – Changing it to an IF statement solved my issue.

     

    Have a good one!

    The contents of this e-mail message and
    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.





  • 6.  RE: Color Format Formula

    Posted 03-23-2021 11:57
    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
    ------------------------------