Discussions

 View Only
  • 1.  Color Coding Formula

    Posted 03-09-2019 19:46
    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"
    )




  • 2.  RE: Color Coding Formula

    Posted 03-09-2019 21:22
    Try this

    If([Work Type]="RD"
    and [Status]<>"Completed",
    and [Today]>=[Target End Date]-Days(2)),"#FFF00")


  • 3.  RE: Color Coding Formula

    Posted 03-10-2019 00:08
    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")



  • 4.  RE: Color Coding Formula

    Posted 03-10-2019 00:54
    If([Work Type]="RD"
    and [Status]<>"Completed"
    and Today() >= [Target End Date]-Days(2),"#FFF00")


  • 5.  RE: Color Coding Formula

    Posted 03-10-2019 01:11
    That worked perfect! 

    Thank you for your patient assistance.

    Dirk


  • 6.  RE: Color Coding Formula

    Posted 03-10-2019 03:01
    Great thx for letting me know.