Use of Averageif while filtering data in multiple columns

I am attempting to average %complete by team (Team#) where sessions are active (Sessions Scheduled). This requires two HAS(@Cell, Criteria) but I am getting an #UNPARSEABLE

=AVERAGEIF([Team#]:[Team#], HAS(@cell, "1" AND [Session Scheduled]:[Session Scheduled], HAS(@cell,"1"), [% Story completed]:[% Story completed])

How can I write this formula so it looks at

  • Team# Where = 1 AND
  • Session Scheduled = 1 THEN
  • Average the above results (% Complete columns)

I feel like I'm close.....🤔

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!