Why can't I convert =IF(COUNTIF(Email:Email, Email1) > 1, 1) to a Column Formula?

James Keuning

Brand new to this app. My formula:

The error:

Where that link takes me:

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Ramzi K

@James Keuning

You cannot convert a formula to a column formula if it contains a direct cell reference. In your case it's Email1. You would only be able to do it if it was Email@row

I hope this helps.

Ramzi

Ramzi K

@James Keuning

You cannot convert a formula to a column formula if it contains a direct cell reference. In your case it's Email1. You would only be able to do it if it was Email@row

I hope this helps.

Ramzi