Formula in Smartsheet that will tell me if the data in 4 different columns is the same

Tanya B

I am looking for a formula in smartsheet that will tell me if the data in 4 different columns is the same. In excel I am able to use =COUNTIF(A3:D3,A3)=4

In Smartsheet I am getting "INVALID COUMN VALUE"

Nick Korna

Hi @Tanya B

If your columns A-D are adjacent to one another for a range, then something like this should work:

=IF(COUNTIF(A@row:D@row, A@row) = 4, "True", "False")

Example:

Hope this helps, but if you've any problems/questions then let us know! 🙂

Nick Korna

Hi @Tanya B

If your columns A-D are adjacent to one another for a range, then something like this should work:

=IF(COUNTIF(A@row:D@row, A@row) = 4, "True", "False")

Example:

Hope this helps, but if you've any problems/questions then let us know! 🙂

Tanya B

Perfect! yes it worked