Color Coding Dates
I am newer to QB, but have found formulas to be a challenge so far.
I am trying to do simple color coding for dates, for example i have 4 columns of dates, that will be populated through the projec...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis format will work, just keep adding conditions like that. But it will return the first condition which is true, so think about he order of the steps in your IF
IF(
[To QC 1] < Today()+Days(1), "yellow",
[Returned QC 1] > Today()+Days(1), "blue")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
IF(
[To QC 1] < Today()+Days(1), "yellow",
[Returned QC 1] > Today()+Days(1), "blue")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Right, but i guess that is not what i am trying to get it to do.
Whenever each date is populated i am looking for it to change the color to something different, so i can "see" visably the stage of the project.
So as each date does get populated it would clear the previous color and change to the most recent color instead.
------------------------------
Bret Osborne
------------------------------
Whenever each date is populated i am looking for it to change the color to something different, so i can "see" visably the stage of the project.
So as each date does get populated it would clear the previous color and change to the most recent color instead.
------------------------------
Bret Osborne
------------------------------
oh wait. I re-read what you said about the order! I think i got it!
I need to go right to left, not left to right! I will try!
------------------------------
Bret Osborne
------------------------------
