#Hey, don’t mean to seem impatient, just

1 messages · Page 1 of 1 (latest)

desert flume
#

oof . . . I completely forgot about it. Writing it up now for you, sorry @keen fossil

keen fossil
#

All good, thanks again 🙂

desert flume
#

The two sheets in this hopefully are useful, feel free to comment if something doesn't make sense https://docs.google.com/spreadsheets/d/1acnDba_HtCF9W3SlGnTjSk70guuv3YNVedOePpC_f-w/edit?usp=drivesdk

Google Docs
Copy of my_cool_gamer_data

The important part

Timestamp,What platform?
2024-03-13,Mobile
2024-03-13,PC
2024-03-13,Mobile, PlayStation,The purpose,The function,The result
Join all the rows together into one blob.
Let's use 🙂 as the join character for now to illustrate,=JOIN("🙂" , H5:H),Mobile🙂PC🙂Mobile, PlayStation🙂...

keen fossil
#

Thank you, I think that might help quite a bit, but I do have one more question for now:

  • Is there a way to display the second- and third-most common answers without needing to scroll through and count them?

Thanks again for your time, I really appreciate you helping me out with this likely very specific and likely confusing project

desert flume
#

Yep! so in the original sheet, the function that pulls the top result is SORTN() (documentation page)

The second argument that this function is used to tell it how many of the "top items" you want. So if I change that argument from 1 to 3, it will list the top 3 items

image.png image.png
Google Docs
my_cool_gamer_data

Form Responses 1

Timestamp,Email Address,What paltforms?

SORTN - Google Docs Editors Help

Returns the first n items in a data set after performing a sort. Sample Usage SORTN(A1:A10, 2) SORTN(A2:C20, 2, 2, B2:B20, TRUE) SORTN(A2:C20, 2, 3, B2:B20, TRUE, 3, FALSE) Syntax SORTN(range, [

keen fossil
#

Would this work if I wanted to skip the full list? If not, is there a way I can? I can make it work if not but compactness would be amazing

desert flume
#

It can be done, but it would be a tangled mess of a function. Maybe instead, you could just have the Top 3 ranking (columns E and F) on a different sheet from the tallied list (columns B and C)?

keen fossil
#

I might but if I were to try to skip right to the top 3 list do you know how I might do that? Would I just nestle it in to what I already have?

desert flume
#

Yep, that's exactly what it'll take. Just putting that first table formula nested inside of the latter one

keen fossil
#

Is there an example? I’m unsure how to fit the SORTN function into it and didn’t really understand what you meant. I tried experimenting with it and couldn’t make it work.

#

This is what I currently have as my function:

=UNIQUE(TRANSPOSE(ARRAYFORMULA(TRIM(SPLIT(JOIN(",",E9:E15),",")))))

keen fossil
#

In addition…

  • Is there a way I can allow a function to overwrite cells?
  • Is there a way I can make form submissions utilize premade rows?
desert flume
#

What do you mean by "make form submissions utilize premade rows?"

keen fossil
#

I’d like the new rows created on form submission to automatically utilize a set format, such as cell fill colors and merged cells