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
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!