Archive
If you have ever tried to use DVARP in a real spreadsheet in Google Sheets and ended up wrestling with awkward workarounds, the DVARP function is the cleaner solution you were looking…
Continue reading →If you have ever tried to use CONVERT in a real spreadsheet in Google Sheets and ended up wrestling with awkward workarounds, the CONVERT function is the cleaner solution you were looking…
Continue reading →If you have ever tried to use TO_DATE in a real spreadsheet in Google Sheets and ended up wrestling with awkward workarounds, the TO_DATE function is the cleaner solution you were looking…
Continue reading →If you have ever tried to use TO_DOLLARS in a real spreadsheet in Google Sheets and ended up wrestling with awkward workarounds, the TO_DOLLARS function is the cleaner solution you were looking…
Continue reading →If you have ever tried to use TO_PERCENT in a real spreadsheet in Google Sheets and ended up wrestling with awkward workarounds, the TO_PERCENT function is the cleaner solution you were looking…
Continue reading →If you have ever tried to use TO_PURE_NUMBER in a real spreadsheet in Google Sheets and ended up wrestling with awkward workarounds, the TO_PURE_NUMBER function is the cleaner solution you were looking…
Continue reading →If you have ever tried to use TO_TEXT in a real spreadsheet in Google Sheets and ended up wrestling with awkward workarounds, the TO_TEXT function is the cleaner solution you were looking…
Continue reading →If you have ever tried to apply one formula to a whole column instead of a thousand copies in Google Sheets and ended up wrestling with awkward workarounds, the ARRAY_CONSTRAIN function is…
Continue reading →If you have ever tried to apply one formula to a whole column instead of a thousand copies in Google Sheets and ended up wrestling with awkward workarounds, the BYCOL function is…
Continue reading →