Skip to main content
Question

Color Coding Formula Help

  • April 23, 2019
  • 0 replies
  • 37 views
In our app we have a date field titled "Initial ISD". I am trying to write a formula that will turn all records with an "Initial ISD" that is 30 days or less from today's date the color red. Any help is greatly appreciated!
    This topic has been closed for replies.

    Here is an example of a row colorization formula for a table report type

    IF(Today()-[Initial ISD] < Days(30), "pink") // but the pink is pretty wimpy.

    you can also use "red" but its so strong a color that it blots out the words.


    You can also use hex codes.  There is a list of them here from Laura another QSP.

    https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=1


    IF(Today()-[Initial ISD] < Days(30), "#F665AB") // this is a decent pink.



    • ChrisBaker1
    • Author
    • Registered
    • April 23, 2019
    This is perfect, thank you!
    • ChrisBaker1
    • Author
    • Registered
    • April 23, 2019
    If I wanted to add another set of conditions to this such as "if it is less than 15 days, then green", how would I add that?
    IF(
    Today()-[Initial ISD] < Days(15), "#00FF00") // green.
    Today()-[Initial ISD] < Days(30), "#F665AB") // this is a decent pink.
    • ChrisBaker1
    • Author
    • Registered
    • April 23, 2019
    Thank you!
    • ChrisBaker1
    • Author
    • Registered
    • April 23, 2019
    I am getting an error on the "Today" on the third line. It states "There are extra characters beyond the end of the formula"?
    • ChrisBaker1
    • Author
    • Registered
    • April 23, 2019
    Never mind, I believe I have it figured out. Thank you again!
    Terms & ConditionsAccessibility statement