Digging Deeper with Google Sheets + Looker Studio
Useful Sheet formulas
"Importrange"
This formula is useful if you want to pull information together from different sheets in real-time, so if you update the original data set it will update in the second sheet. If I was to just copy and paste it is now static. Curly Brackets
VLOOKUP
Great for looking up a reference in a set of data or on a different sheet
ARRAYFORMULA
Instead of dragging the formula it automatically fills out the column without the dragging.
SQL - sequeal
You can pull multiple columns of data using one formula
I can't wait to try these ideas. Thanks David.
This formula is useful if you want to pull information together from different sheets in real-time, so if you update the original data set it will update in the second sheet. If I was to just copy and paste it is now static.Curly Brackets
No comments:
Post a Comment