I am creating a KPI app for our mattress manu...

(Crown Posture Bedding QLD) #1

I am creating a KPI app for our mattress manufacturing factory.

Can anyone help me with this formula?

I have a column (Name) which lists all of our staff names.

However only four of our staff (Overlock)

The formula below works if I enter only one staff members name. I am trying to SHOW_IF =CONTAINS([Name], “JASON”)

How would I enter multiple staff members names?

(Crown Posture Bedding QLD) #2

Hi I have solved my question with this expression.

SHOW IF =IN([Name], LIST(NAME 1, NAME 2, NAME 3, NAME 4))