What am I doing wrong  SumIf referencing specific cell
Hollie Green
✭✭✭✭✭
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

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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!