Forum Discussion
Solved
Don't even know if this is possible....
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
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.
2 Replies
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.
