Integrate sheet Summary results to Column formula

Kevin7859
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, [ ], { }

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!