How can I fix the error #UNPARSEABLE

Options

=IF(Aged@row > Terms@row, "Red", IF(Aged@row = Terms@row, "Yellow", IF(Aged@row < Terms@row, "Green",IF(Payment Status@row="Yes","Green"))))

Best Answer

  • Sherika Burton
    Answer ✓
    Options

    =IF([Payment Status]@row = "Yes", "Green", IF(Aged@row > Terms@row, "Red", IF(Aged@row = Terms@row, "Yellow", IF(Aged@row < Terms@row, "Green"))))

    I figured it out (If formula if you want to use symbol)

Answers

  • Sherika Burton
    Answer ✓
    Options

    =IF([Payment Status]@row = "Yes", "Green", IF(Aged@row > Terms@row, "Red", IF(Aged@row = Terms@row, "Yellow", IF(Aged@row < Terms@row, "Green"))))

    I figured it out (If formula if you want to use symbol)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!