Sign in to join the conversation:
=SUMIFS(CATEGORY:CATEGORY, QUESTION4, [OverallTime (Minutes)]:[OverallTime (Minutes)])
this works fine...
=COUNTIFS(CATEGORY:CATEGORY, QUESTION4)
Please help
Can you provide a screenshot or more details as to what is in each column?
Hi,
what do you try to achieve ? I'm pretty sure this one will work :
=SUMIFS([OverallTime (Minutes)]:[OverallTime (Minutes)],CATEGORY:CATEGORY, QUESTION4)
Best regards,
Paul.
Eventually I am needing to average, by category, the Overall Time (minutes). So, Have the count already, by category. I am now trying to Sum the minutes and then divide Minutes by count to get an average. I am sure there are better ways to do this, but just getting my feet wet with the formulas.
Thanks Paul. It works fine..
I am sure there are better ways to do this
You're actually right on the money with the best approach already.
=SUMIFS(Stuff) / COUNTIFS(More Stuff)
Unfortunately Smartsheet doesn't have an AVGIFS() function...
Smartsheet's AVG IF looks like this:
=AVG(COLLECT(range-to-average, criterion-range-1, criterion-1))
Craig
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
