Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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.

image.png

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

  • 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

  • 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! 😊

  • ✭✭✭

    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!

Trending in Formulas and Functions