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
- Customer Resources
- 67.1K Get Help
- 442 Global Discussions
- 154 Industry Talk
- 503 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!