SUMIF (Collect( yyyy; with control button


could you please look up following formula which is "unparseable"

=SUMIF(COLLECT([VS FF&E]:[VS FF&E];Archiv:Archiv; = active))

"active" is for the control button I use in the column. It is either active or not.

I will only sum the value of all rows that are not active.

Hope you can help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!