CIFL Office Hours 6/8

This is a recurring office hours session every Thursday, where we chat all things Google Sheets + automation.

Before diving into questions this week, I previewed a presentation I'm giving as part of a workshop in a few weeks - walking through the 'why' of automating your work in Google Sheets.

For Q&A, this week's theme was Google Sheets formulas, and how you can use them to automate your grunt work.

For answers to this week's questions, check out this Google Sheet:

Questions we covered this week:

1. How do you combine data from two different columns into one in Google Sheets?
2. How do you combine data from multiple sheets (from Form responses) into one Sheet, but only if they're from certain dates?
3. Is it possible to view data from right-to-left instead of left-to-right in Google Sheets?

[andrewcopp]

Good shit. With that being said, I would love to see more before and afters in that deck. To show how you actually make people's life easier. I.e. how their processes were before you and now how they are.

[andrewcopp]

Bro, good shit on the answer too much question. I didn't even know you could use curly brackets like that. Lol thank you so much my man