Continue format

fb_smd
fb_smd ✭✭
edited 10/03/23 in Formulas and Functions

how can I apply this formula to all the column? so far it's not working and says that the syntax isn't quite right. =IF(Balance@row > Balance15, "True", "False")

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Actually... Now that I think about it, that shouldn't be working the way you want it to. It is basically going to always compare "@row" to the second to last row and not necessarily the row above.


    You are going to need to insert an auto-number column (formatting doesn't matter) and then a text/number column (called "Row" in this example) and use this column formula:

    =MATCH([Auto-Number]@row, [Auto-Number]:[Auto-Number], 0)


    Then use this instead:

    =IF(Balance@row > IFERROR(INDEX(Balance:Balance, Row@row - 1), Balance@row), "True", "False")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!