What am I doing wrong - SumIf referencing specific cell

This is my formula =SUMIFS({Time in hours}, {QA}, [Primary Column]@row, {Task}, $[Column3]$8)

It works perfectly in the first cell of the column but when I try to turn it into a column formula I get an error of the syntax isn't quite right. No matter what row in the column my formula is in I want it to reference Column3 cell 8 but want the other references to be flexible.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭

    @Hollie Green

    You cannot have an absolute reference in a column formula. As a work around, create a Sheet Summary formula with the absolute reference call. Then in your column formula build out the formula to refer to the sheet summary.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!