Sum values from multiple columns when associated checkbox is ticked


I am trying to use the IF formula to sum multiple column values if an associated column checkbox is ticked - basically duplicating the formula below to the other checkbox field and specific columns. It tried the "AND" function - without luck.

Any expert able to assist?

Thank you


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!