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

  • Nick Korna
    Nick Korna Community Champion
    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

  • Nick Korna
    Nick Korna Community Champion
    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! 😊

  • mragans23
    mragans23 ✭✭✭

    OMG yes, thats it. Thank you so much.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!