Forum Discussion

iamblue91's avatar
iamblue91
Frequent Visitor
9 years ago
Solved

[Beginner Question] Calculated column?

I'm tyring to create a calculated column that will generate a yes / no.    (Not actual data or names used)   The column "Permission Issued (code)" has options A, B, C, No, n/a. I want the new col...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    A switch statement might also be worth considering:

     

    = SWITCH(
	[Permission Issued (code)],
	"No","No",
	"n/a","n/a",
	"Yes"
)
paulag's avatar
paulag
Advocate I
9 years ago

create a calcualted column with an IF statement

 

=IF([Permission Issued (code)]="No","No", IF([Permission Issued (code)]="n/a","n/a","Yes")

Anonymous's avatar
Anonymous
Not applicable
9 years ago

A switch statement might also be worth considering:

 

= SWITCH(
	[Permission Issued (code)],
	"No","No",
	"n/a","n/a",
	"Yes"
)
  • paulag's avatar
    paulag
    Advocate I
    9 years ago

    Switch is probably easier than the IF statement