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 little help at first.
I really appreciate the kind guidance I have been receiving!!!!
Dirk
First Color Coding Formula Effort
Formula syntax error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
If([Work Type]="RD",
[Status]<>"Completed",
[Today]>=[Target End Date]-(2) Days),"#FFF00"
)
Question
Color Coding Formula
+8Try this
If([Work Type]="RD"
and [Status]<>"Completed",
and [Today]>=[Target End Date]-Days(2)),"#FFF00")
If([Work Type]="RD"
and [Status]<>"Completed",
and [Today]>=[Target End Date]-Days(2)),"#FFF00")
+8Still 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")
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.