Getting Started

 View Only
  • 1.  Formula for color coding more than one field

    Posted 02-20-2023 12:48

    I want to color code two fields within the same table to highlight when they are past due. 

    Is there a way to add another due date field to this formula? 
    If ([Medical Record/Pharmacy Review-Due Date] < Today(), "red", "")

    Thank you!! 



    ------------------------------
    Nichole Stebane
    ------------------------------


  • 2.  RE: Formula for color coding more than one field

    Posted 02-20-2023 14:02

    np,

    IF(

    [Medical Record/Pharmacy Review-Due Date] < Today(), "red",

    [some other -Due Date] < Today(), "blue")

    There is a great list of colours here https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000000&dr=1



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Formula for color coding more than one field

    Posted 02-20-2023 15:52

    Thank you Mark! Can they both be red or do they have to be different colors?



    ------------------------------
    Nichole Stebane
    ------------------------------



  • 4.  RE: Formula for color coding more than one field

    Posted 02-20-2023 15:53

    They can be the same color or not, it's up to you.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Formula for color coding more than one field

    Posted 02-20-2023 15:57

    Your help is very much appreciated!! 



    ------------------------------
    Nichole Stebane
    ------------------------------



  • 6.  RE: Formula for color coding more than one field

    Posted 02-20-2023 15:56

    Not to complicate this any further, but how could a formula like this be adjusted to not include weekends?



    ------------------------------
    Renee Williams
    ------------------------------