Color Coding Formula
Hi Just getting started on Color Coding. Can someone help review? I am having a syntax error. Usually once I have an understanding, The issue is resolved. But I am not an IT guy, and I need a...
Forum Discussion
Still and error message. [Today] is supposed to be the current date. Its not an actual field.
Formula syntax error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
If([Work Type]="RD"
and [Status]<>"Completed",
and [Today]>=[Target End Date]-Days(2)),"#FFF00")
Formula syntax error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
If([Work Type]="RD"
and [Status]<>"Completed",
and [Today]>=[Target End Date]-Days(2)),"#FFF00")