1

I want to sort the responses by names alphabetically Column A (Simple)

I want to apply payment types from a drop down linked to the person's name Column G (Simple)

I want to do both of these things with new form responses coming in (Impossible?!)

Please help.

Sample Sheet with Responses

1

1 Answer 1

0

Delete the formula in cell A2 and use this { array expression } in cell A1:

={ 'Form Responses 1'!C$1:E }

Then create a filter view to sort the sheet by column A. Filter views can be saved for re-use. You can open a filter view with a link in cell H1 like this:

=hyperlink("#gid=1483996664&fvid=1156058788", "Sort by A (Admin Notes)")

See your sample spreadsheet.

3
  • Excellent suggestion! Now if filter views only worked on mobile I would be set! I am not sure about Android but on iOS Sheets I cannot enable the filter view with the link :( Commented Oct 4, 2022 at 23:38
  • I do not know how to make filter views work on mobile. You will need a different solution. This question did not specify that detail, so please post a new question. Commented Oct 5, 2022 at 6:15
  • I gather that this is your first question at Stack Exchange. See What should I do when someone answers my question? Commented Oct 5, 2022 at 6:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.