Skip to main content
Question

Color coding based on Next Due Date field

  • January 18, 2024
  • 0 replies
  • 110 views
Forum|alt.badge.img+4

I want to color rows that are past my Next Due date field Red.  I get that to work.  But then, I also want to color code anything that is 30 days or less out Yellow.  I tried this....

If([Next Due Date]<Today(),"RED")
If([Next Due Date]<Today()-Days(30), "Yellow")

It not only doesn't do red anymore, after working as a single line, but it also won't color yellow.



------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    Unlike Excel you don't need to nest your IFs for most logic situations.  Just list the conditions in the sequence you want them check d the first one wins.

    If(

    [Next Due Date]<Today()-Days(30), "Yellow",

    [Next Due Date]<Today(),"RED"])



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement