Integrate sheet Summary results to Column formula

Kevin7859 ✭✭✭✭
edited 01/17/24 in Formulas and Functions

How can I integrate the AVG sheet summary result into a column formula?

=SUM([OSS Count]@row / [AVG OSS Count])

it comes back as #unparseable

Best Answer

  • Kevin7859
    Kevin7859 ✭✭✭✭
    Answer ✓

    I figured it out by clicking on the result in the sheet summary it added the correct formula reference.

    =SUM([OSS Count]@row / [AVG OSS Count]#)

    So the # after the name is referencing the sheet summary. instead of the @row, [ ], { }


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!