Apr 05 2023 08:15 AM
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
Apr 05 2023 08:19 AM
SolutionLet'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.
Apr 05 2023 08:23 AM
Apr 05 2023 08:19 AM
SolutionLet'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.