Forum Discussion

HelpmeRhonda's avatar
HelpmeRhonda
New Member
1 year ago
Solved

IF & DATEDIFF - 3 Status Help with my function Please

I have a status Column with 3 texts: Completed, In Progress, Not Started.  I would like to pull for both "In Progress" and "Not Started" or pull for all but "Completed".     This works but what...
  • lbendlin's avatar
    1 year ago

    [TASK_STATUS]<>"Completed"

     

    or

     

    [TASK_STATUS] IN {"In Progress","Not Started"}