Trying to write a formula that would total the sum of the $, if checkmark present


Best Answer

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    Answer ✓

    Hi @JGenco_CK - You'll need a SUMIF for that.

    =SUMIF([Targeted for Reimbursement]:[Targeted for Reimbursement], 1, [Target Reimbursement Amount]:[Target Reimbursement Amount])

    Please let me know if this works for you!

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!