Kevin7859 · Program Specialist IV · ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	10

About Me

About Me

Title	Program Specialist IV
Area of Expertise	Data analysis
How I Use Smartsheet	Data repository and analysis

Analytics

67

Posts

308

Visits

323

Points

Sep 9, 2023

Join Date

Mar 7, 2025

Last Active

Reactions

• Insightful 2

  2
• Vote Up 21

  21
• Awesome 3

  3

• Activity
• Discussions24
• Comments43

• Re: Integrate sheet Summary results to Column formula

  Kevin7859

  01/17/24
  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 summa…
  1 ·

• Re: Calculate count based on certain criteria.

  Kevin7859

  12/12/23
  Thank you all for the help on this, we ended up with the following formula: =IF(OR(Sit@row = "NA", Sit@row = "", Removed@row = 1), 0, COUNTIFS([School Name]:[School Name], [School…
  2 ·

• Re: Multiple Values Filtered to One Cell

  Kevin7859

  10/05/23
  That worked better than expected. Thank you
  1 ·