flag if > 6000

=IF([Current Mileage]@row - [Service Mileage / Hrs]@row, >6000, 1)

What am I doing wrong? Iwant to flag if the difference is greater than 6,000

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hi @Samuel Dowdy Jr ,

    Try this:

    =IF(([Current Mileage]@row - [Service Mileage / Hrs]@row) >6000, 1,0)

    The syntax for an IF statement is: IF( logical_expression, value_if_true,  [ value_if_false ])

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    Hi @Samuel Dowdy Jr ,

    Try this:

    =IF(([Current Mileage]@row - [Service Mileage / Hrs]@row) >6000, 1,0)

    The syntax for an IF statement is: IF( logical_expression, value_if_true,  [ value_if_false ])

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!