Forum Discussion
Calcualted column is returning "#Name?"
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("Monitorin...
john john If the Category column is a choice column you can simplify the formula to:
=IF(OR(Category="Pending",Category="Monitoring And Evaluation Plan",Status="Inactive",ISBLANK(Status)),"Hide","Show")
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)