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
Check out the Formula Handbook template!