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 project. As each progression of the project is complete i would like to have that date color coded to show the "stage".so column A,B,C,D, then i will select colors for each column. If no dates are populated, then it would not be color coded. I believe this should be some type of IF statement, but not sure how to formulate it. Thank you for your help!
If([To QC 1]<(Today()+Days(1)), "yellow",[Returned QC 1]>(Today()+Days(1)), "blue")but when i got to the second line, is does not read the 2nd next statement.I also tried
If( not IsNull([To QC 1]),"yellow",If( not IsNull([returned QC 1]),"blue"))
but it only reads the "TO QC 1" statement, ignoring the first line.
I know i am likely missing something basic, but again newbie! :)
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!