SOLVED

Don't even know if this is possible....

Copper Contributor

I want to track the how many of my teams records on our database have up to date consent.  When I pull the data, we have four columns (representing phone/mail/sms/email) showing whether the supporter has opted in, opted out, or is unknown.

 

What I want to do is find a formula that will indicate Y if any of the columns contain opt in/opt out, and N if the columns only contain unknown.

 

If anyone out there can help before my head explodes I'd be hugely grateful.

Thank you

2 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Tina_Burdett 

Let's say the columns are K to N, with data starting in row 2.

In another column, enter the following formula in row 2:

 

=IF(COUNTIF(K2:N2, "unknown")=4, "N", "Y")

 

Fill down.

I knew it would be easier than I realised. Thank you.
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@Tina_Burdett 

Let's say the columns are K to N, with data starting in row 2.

In another column, enter the following formula in row 2:

 

=IF(COUNTIF(K2:N2, "unknown")=4, "N", "Y")

 

Fill down.

View solution in original post