I have the following formula for a single line of text Calculated column named ShowInApp:

IF(OR(Status="Inactive",ISBLANK(Status)),"Hide",IF(FIND("Pending",[Category]),"Hide",IF(FIND("Monitoring And Evaluation Plan",[Category]),"Hide","Show")))

But on some cases I will get #Name? or #VALUE!, as follow:

enter image description here

Any Advice? Thanks

In short I want to set the calculated column to Hide, if any of the following is true:

  1. Status is blank
  2. Status = inactive
  3. Category contain the word Pending
  4. Category contain "Monitoring And Evaluation Plan"

Else to set the calculated column to Show.

  • 1
    Do you really need "contain" condition for category or exact "equal to" condition will be fine? Sep 1, 2022 at 10:17
  • @GaneshSanap i need contain, as we have statues such as "Pending approval", "pending closure". etc..
    – John John
    Sep 1, 2022 at 11:09

1 Answer 1


Try using this formula:

        [Status] = "Inactive",
        NOT(ISERROR(FIND("Pending", [Category]))),
            NOT(ISERROR(FIND("Monitoring And Evaluation Plan", [Category]))), "Hide", "Show"

Documentation: Examples of common formulas in lists

  • 1
    worked thanks...
    – John John
    Sep 1, 2022 at 11:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.