Enter number in cell based on which checkbox is checked

I'm new at this so patience is appreciated.

I want to fill a cell with 2%, 4% or 6% based on one, two or three checkboxes. If checkbox Credit 1 Complete is checked, Credit Obtained = 2%; Credit 2 complete, Credit Obtained =4%; and Credit 3 complete checked, credit obtained =6%. Credit Obtained cannot be 6% without the other two boxes being checked. Any suggestions on how to write a formula for this?

Thank you!

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @llambert39581

    When writing an IF statement for a sequential process, start at the end of the process and work backwards.

    =IF([Credit 3 complete]@row=1, 0.06. IF([Credit 2 complete]@row=1, 0.04, IF([Credit 1 complete]@row=1, 0.02)))

    Will this work for you?

    Kelly

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @llambert39581

    When writing an IF statement for a sequential process, start at the end of the process and work backwards.

    =IF([Credit 3 complete]@row=1, 0.06. IF([Credit 2 complete]@row=1, 0.04, IF([Credit 1 complete]@row=1, 0.02)))

    Will this work for you?

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!