Miguel Yandu

Miguel Yandu

1620312503

ARRAYFORMULA in Google Sheets - 4 Useful Hacks Included 🎁

ARRAYFORMULA in Google Sheets distributes your calculation to all of the rows in a selected column. It saves your spreadsheet capacity and power. After watching this tutorial you won’t have to copy the same formula manually ever again. In this video, we present the most useful Railsware Product Academy hacks - watch till the end!

πŸ“˜Read this useful blog post to learn more tricks with ARRAYFORMULA: http://bit.ly/blogpost-rw-array
πŸ”ŒWe use Coupler.io to import data to Google Sheets from various sources (e.g. Pipedrive, CSV, Hubspot, and many more): http://bit.ly/coupler-rw-array

πŸ’ͺGet a personal copy of the practice sheet we use in the video: http://bit.ly/practice-rw-array

  • 0:00 - Why should you use ARRAYFORMULA?
  • 1:05 - ARAYFORMULA syntax in Sheets
  • 2:31 - Remove unneeded values using a Railsware Academy hack!
  • 6:48 - ARRAYFORMULA with nested IF
  • 8:48 - Secure your ARRAYFORMULA and its output
  • 9:15 - Use ARRAYFORMULA with texts
  • 11:05 - ARRAYFORMULA + SUMIF
  • 13:12 - Combine the column header and ARRAYFORMULA in a single cell
  • 14:01 - SUMIFS workaround: use ARRAYFORMULA + SUMIF + &

We’d love to hear from you!πŸ™‹β€β™€οΈπŸ’¬Share your ARRAYFORMULA cases in the comments ⬇️ Make sure to subscribe and hit the bell button to learn more Google Sheets tricks coming up soon!

Design and video production: Oleg Gorovoi, Vlad Shagov, Ludmila Shevchenko
Speaker: Anastasiia Avramenko

#google-sheets #developer

ARRAYFORMULA in Google Sheets - 4 Useful Hacks Included 🎁