Google Sheets - Database Functions

[@garyjoaquin]

Outstanding presentation!

[@sadhucat4476]

Thanks for the clear explanations!

[@vals.]

Learned more than expected, Thanks!

[@jaykkyawal2215]

Hitting Like button is my first function when I click on any videos before starting to watch videos of this channel

[@walterpaiva719]

Thanks. I'm not used to these functions but it's good to know and try to work with them

[@mehmetkaya4330]

Great tutorial! Thanks

[@jawsstech]

great work

[@learningisbliss1143]

Does this change if the data being referenced is a table?

[@PencilBoxID]

Nice

[@raulbezerra1929]

Ty man, i had some problems with dcount couse i didnt know this rules.

[@pichit.raetai]

Thank you

[@jamshaidsultandurrani5870]

HEY , CAN YOU HELP ME HOW TO CONVERT FORMULA INTO VALUE AUTOMATICALLY

[@noobz8613]

Appscripts

[@netboy1102]

In appscript Setformula

[@cellusgrove]

Hey I have went thru majority of your vids amd they are great but I dont see a vid to resolve my issue. I am trying to pull data from a google sheet to another only if it meets particular conditions. Example I want dates that expire this month to automatically pull from all sheets onto one master sheet. Pulling data is easy but pulling data based on conditional formatting is my concern.

[@antonizieba]

Hey, try to use the Google Query function with import range

[@jwadamucci]

I don’t know if conditional formatting rules come through with importrange, or even query. You can set a flag/value on a new column, based on the same conditions as your formatting, and pull that inside the importrange with a query.