Why can't I convert =IF(COUNTIF(Email:Email, Email1) > 1, 1) to a Column Formula?
Brand new to this app. My formula:
The error:
Where that link takes me:
Best Answer
-
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 Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
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 Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!