Formula Text
Need a formula text field based on two other text fields
Would like my field to display "Done" when
Application Status is NOT equal to approved
Closure Status is NOT equal to approved
...
Forum Discussion
If those two criteria are the only that matter in this instance, the formula below will get it done.
If([Application Status]<>"Approved" and [Closure Status]<>"Approved", "Done")
If you have other options this formula should display based on different values in Application and Closure status, this formula can definitely be expanded upon.
------------------------------
George Hambel
Project Manager
Synctivate
------------------------------
