Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Nested CountIf statement help needed

Kelly Ospina
Kelly Ospina ✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts


I need to create a formula where if a box is checked in one column, a figure in another column gets included in a sum in another cell at the bottom of the column with the numeric value. 

This is what I've got, but I'm getting error messages: =COUNTIF(QTR:QTR, "True", SUM(Blackline:Blackline))

I'm not sure exactly what I'm doing wrong, hoping someone can help. 

Thanks so much!


This discussion has been closed.