Overwrite a formula when a box is checked
I am currently using the following formula If( [Form 7 Due Date] <= 5 and [Form 7 Due Date] > 2, "<div style=\"background-color:Yellow;\">"&[Form 7 Due Date]&"</div>", [Form 7 Due Date] <= 2 ,"...
Forum Discussion
The IF statement processes the tests in the order that they are listed, lpooking for the first est which is true. Perhaps you want this:
If([Form 7 Completed] = true, "<div style=\"background-color:White;\">Submitted</div>",[Form 7 Due Date] <= 5 and [Form 7 Due Date] > 2, "<div style=\"background-color:Yellow;\">"&[Form 7 Due Date]&"</div>", [Form 7 Due Date] <= 2 ,"<div style=\"color:white; background-color:Red;\">"&[Form 7 Due Date]&"</div>", [Form 7 Due Date] <= 5 and [Form 7 Due Date] > 2 and [Form 7 Completed] = true, "<div style=\"background-color:White;\">Submitted</div>", [Form 7 Due Date] <= 2 and [Form 7 Completed] = true, "<div style=\"background-color:White;\">Submitted</div>")