averageif and summary fields working inconsistently
I'm using the averageif formula in the sheet summary. it works perfectly for the first line. I've literally copied and pasted it into another field in the summary, and it's no longer working. help?
I've tried under multiple names, validated the names/format by copying and pasting them, and confirmed the calculation is not correct. What am I missing?
Answers
-
Hello!
I haven't had good "luck" with sheet summaries displaying the correct data either and honestly their ability to refence the data in the sheet feels limited. I do see that each of your formulas reference "[Final Score]1" (same with HR Central Employee Name). What happens when you remove the "1" from each of these to reference the whole columns?
Alternatively, I have had a lot of success setting up a separate metrics sheet where I can add helper columns in (such as Name), to do all my formulas. An example of mine is below:
First column is Name (could be employee name for you), and all the other columns are a series of formulas I want to use that reference that Name column, along with different criteria. In my experience, this is much quicker and easier than using the sheet summary data.
If you ultimately want it in the sheet summary data, maybe so you can add it in a dashboard as a widget, all you need to do is create the field and then have it reference a single cell in your metrics sheet (vs. putting a whole formula in it).
Hope this helps!
Jaime
-
lawd. I thought that the : indicated entire column and literally didn't even think about the fact that the 1 might be limiting that. all better, thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!