-1

I do this process on a daily basis and was wondering if I could automate this in order to save time. This is what I want to do:

Step 1: Select column with header "C". Replace all "?" by "w". Replace all "1" by "v"

Step 2: Sort column with header "company" by A-Z

Step 3: Sort column with header "priority" by A-Z. If column with header "priority" is not found, move to next step (sometime priority column is not present)

Step 4: Sort column with header "C" by Z-A

Step 5: Filter column with header "C" for blanks

Step 6: Sort column with header "OV comment" by A-Z

Step 7: Sort column with header "PV" by Z-A

Step 8: Filter column with header "C" for all

Please refer to the following link to see a sample file: https://docs.google.com/spreadsheets/d/1bp1jcb3Ex6cdURbU9ScVJO_gTVyyeskojn1_S97-fPk/edit?usp=sharing

Improve this question
1
  • 1
    Have you started writing the script? If so, show us what you have so far. Commented Apr 14, 2017 at 5:23

1 Answer 1

Reset to default
0

It's possible. Looking around here at Stack Overflow would pretty much have what you need (along with a little bit of googling).

  1. Get column by name. Search and Replace your specified characters (possibly simpler if you use replaceText()).

  2. Sort alphabetically (refer here for any other type of sorting).

  3. See #2. Use an if condition.

  4. See #2.

  5. Filter for blank/empty cells.

  6. See #2.

  7. See #2.

  8. See #5.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

With all that said, if you were hoping for an actual working code to be provided, unfortunately, Stack Overflow is not a free code writing service.

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.