2 Part Question on Averages & Calculations in Reports

VinceA ✭✭✭
edited 02/08/24 in Formulas and Functions

Hi folks,

2 part question:

  1. here is that when looking at individual rows in a Report, the calculations are correct for representing % difference between two #'s as seen below (difference between A and B = C). For example in the green boxed check-marked area you can see that the calculations make sense as would all of the other individual rows. However, it doesn't get reflected in a roll-up AVERAGE when perhaps you'd think it would. What displays is the Average of all of the fields for that column. How if in any way can this be displayed or corrected other than working through a Metrics Sheet, if at all.
  2. I didn't see any update in the Community for several requests regarding ability to have these rolled-up Averages and/or Summaries configured in a Chart Widget for Dashboards rather than the use of a Metric Sheet. Is that still the case or is this doable.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!