Want to add cells and return 1/2 if they don't equal a cell ERROR

Options
Tabitha
Tabitha
edited 02/17/22 in Formulas and Functions

=SUM(IF([Reel Stop]@row:[Quantity Scrapped]@row = [Reel Start]@row, 1, 2))

Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓
    Options

    Your SUM syntax is SUM(number1, [number2, ​...]), and it should be inside your IF, not outside. The IF syntax is IF(logical expression, true condition, false condition).

    Try this:

    =IF(SUM([Reel Stop]@row, [Quantity Placed]@row, [Quantity Scrapped]@row) = [Reel Start]@row, "YES", "NO")

    Your logical expression is SUM([Reel Stop]@row, [Quantity Placed]@row, [Quantity Scrapped]@row) = [Reel Start]@row, true condition is "YES", false condition is "NO".

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓
    Options

    Your SUM syntax is SUM(number1, [number2, ​...]), and it should be inside your IF, not outside. The IF syntax is IF(logical expression, true condition, false condition).

    Try this:

    =IF(SUM([Reel Stop]@row, [Quantity Placed]@row, [Quantity Scrapped]@row) = [Reel Start]@row, "YES", "NO")

    Your logical expression is SUM([Reel Stop]@row, [Quantity Placed]@row, [Quantity Scrapped]@row) = [Reel Start]@row, true condition is "YES", false condition is "NO".

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

  • Tabitha
    Options

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!