Forum Discussion

DirkRuana's avatar
DirkRuana
Qrew Captain
7 years ago

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 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"
)

reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Try this

    If([Work Type]="RD"
    and [Status]<>"Completed",
    and [Today]>=[Target End Date]-Days(2)),"#FFF00")
  • DirkRuana's avatar
    DirkRuana
    Qrew Captain
    7 years ago
    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")

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    If([Work Type]="RD"
    and [Status]<>"Completed"
    and Today() >= [Target End Date]-Days(2),"#FFF00")
  • DirkRuana's avatar
    DirkRuana
    Qrew Captain
    7 years ago
    That worked perfect! 

    Thank you for your patient assistance.

    Dirk