SUMIF with checkbox condition

David Stokes
David Stokes ✭✭
edited 09/14/23 in Formulas and Functions

I need help writing a formula to apply a mark-up percentage if the checkbox is applied.

Annual revenue is sum of date range. If checkbox is activated, then 1.5% is added to the sum. If no checkbox is present, then it is just the sum of the date range.

thanks for any help.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!