I'm attempting to solve what I think is a fairly simple problem. We are using NPSP, and track our board members on the Contact level. For some complex reporting reasons, I need a way to simply display the value of the Accounts Primary Contact Board Member Status as text on the account record.
I could do this in flow pretty easily, but would like to try a formula first.
My current formula is as follows:
IF(AND(ISPICKVAL(npe01__Primarycontact__r.Board_Member__c, "Current", Current),
IF(AND(ISPICKVAL(npe01__Primarycontact__r.Board_Member__c, "Former", Former),
IF(AND(ISPICKVAL(npe01__Primarycontact__r.Board_Member__c, "Null", Null)
The values for the picklist in question are Current, Former, and no selection/null.
When attempting to save I'm getting the "missing parentheses" error.
I originally tried this formula which I found on trailhead
IF(AND(ISPICKVAL( Picklist , "A"), FormulaField = "A"), "Result A",
IF(AND(ISPICKVAL( Picklist , "B"), FormulaField = "B"), "Result B",
IF(AND(ISPICKVAL( Picklist , "C"), FormulaField = "C"), "Result C",
FormulaField )))
However I'm unsure of how to populate this with my current fields or if it would even work. I'm not sure what "FormulaField" would be, since it's not accessible to me as I haven't saved the current formula I'm working on.
Any assistance would be greatly appreciated! Or if there's another, simpler way I can achieve this, that would be great too!