Syntax error when trying to convert to a Column Formula from a cell
So I get this. The Column type is a Drop List, however even after creating a new Column (Text/Number), adding the same formula which works, I get the same error.
This is my formula:
=LEFT([Final "SEVERITY" Code Assigned:]1, 1) + LEFT([Final "PROBABILITY" Code Assigned:]1, 1)
Final "SEVERITY" Code Assigned: = "1Catastrophic, Final "PROBABILITY" Code Assigned: = AFrequent. Result: 1A
What can I do to convert successfully to Column Formula?
Best Answer

If I am understanding your ask, change your row call from 1 to @row
Original:
=LEFT([Final "SEVERITY" Code Assigned:]1, 1) + LEFT([Final "PROBABILITY" Code Assigned:]1, 1)
Updated:
=LEFT([Final "SEVERITY" Code Assigned:]@row, 1) + LEFT([Final "PROBABILITY" Code Assigned:]@row, 1)
Answers

If I am understanding your ask, change your row call from 1 to @row
Original:
=LEFT([Final "SEVERITY" Code Assigned:]1, 1) + LEFT([Final "PROBABILITY" Code Assigned:]1, 1)
Updated:
=LEFT([Final "SEVERITY" Code Assigned:]@row, 1) + LEFT([Final "PROBABILITY" Code Assigned:]@row, 1)

That worked perfect🤗. Thank you!

Your Welcome.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 64 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!