If Or Formula Help
My formula is working in Excel, but not in Smartsheet. I am still fairly new to smartsheet so any help would be appreciated.
Basically its looking at the GLAcct column and find certain values and creating key terms for those values. Ex: If GLAcct = 710111 or 710121, then show Key Salary.
Best Answer

Hi @mragans23,
In Smartsheet you'd need to add @row to the GLAcct portion of your the formula.
For example, the first section would be:
=IF(OR(GLAcct@row = "710111", GLAcct@row = "710121"), "Key Salary")
Once you've entered it for one row, you can then right click the cell and "Convert to Column Formula" to have it applied to all rows in the column.
Other than that, I think everything should be OK once you add the @row in.
Hope that helps; any questions etc. then just post! 😊
Answers

Hi @mragans23,
In Smartsheet you'd need to add @row to the GLAcct portion of your the formula.
For example, the first section would be:
=IF(OR(GLAcct@row = "710111", GLAcct@row = "710121"), "Key Salary")
Once you've entered it for one row, you can then right click the cell and "Convert to Column Formula" to have it applied to all rows in the column.
Other than that, I think everything should be OK once you add the @row in.
Hope that helps; any questions etc. then just post! 😊

OMG yes, thats it. Thank you so much.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!