Welcome!

Count 1 row and get an average based on a score in another row

Hello,

How can I use this function that I know in Excel, but in Smartsheet?

=SUM(J1:J5)/COUNTA(I1:I5)

J - column( scores ) = either a 1 or a blank cell

I - column = customer service

Thanks

Capture SS.PNG

Formulas

You can use the same formula with a slight edit. Count will not count empty cells.

=SUM(J1:J5) / COUNT(I1:I5)

That is what I was looking for! Thanks very much.

Weighted Average
how to get the formula to get the weighted average of the scrap
Date Logic for Requests Created After Business Hours
I want to set up Smartsheet so that if a request is submitted on the same day and the submission time is between 6:00 PM and 12:00 AM, the Request Submitted Date should automatically move to the next day. For all other cases, it should remain the same day.
can I get automated reminders for a 30 day check in when dates in my start date column are different
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.