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...
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.
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.
