Collecting and Averaging survey score excluding ""N/A" as an answer
I have a roll-up sheet from a survey in another smart sheet. There are 12 questions and several Project managers that are being surveyed. I currently have 1 issue remaining. I can collect and average the survey scores for each project manager, unless the person completing the survey selected “N/A” as an option. My current code is below, but I can't figure out where to put the formula to ignore “N/A”.
=IFERROR(AVG(COLLECT({CBRE PM Client Satisfaction Survey Range 7}, {CBRE PM Client Satisfaction Survey Range 2}, [Project Manager]@row)), "”)
Answers
-
Hi @scottposey
Smartsheet will usually ignore any result that is not a percentage, assuming you've the answers listed as a percentage or number in the Average/Collect formula. It will help if you could share a sample data set of the responses that correspond to CBRE PM Client Satisfaction Survey Range 7.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!