Forum Discussion

OIS-APPS1DEV's avatar
OIS-APPS1DEV
Qrew Member
2 years ago

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



------------------------------
OIS-APPS1 DEV
------------------------------

1 Reply

Sort By
  • GeorgeHambel's avatar
    GeorgeHambel
    Qrew Trainee
    2 years ago

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