IF formula

Options

Can someone tell me what I am doing wrong with this formula? If the checkbox is checked, I need the value to be zero, if it is not checked then I need the formula to work:


=IF([Existing current WJA server]@row = 1, 0, IF([Existing current WJA server]@row = 2, [How many WebJet Admin Server Instances required?]@row * 4))

Best Answer

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    Answer ✓
    Options

    I'm assuming that "Existing current WJA server" is your checkbox column. If so, I would try the below formula.

    =IF([Existing current WJA server]@row = 1, 0, [How many WebJet Admin Server Instances required?]@row * 4)

    School of Sheets (Smartsheet Partner)

    If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!