I had recently had to use a FORMULA type in a SuiteScript 2.0 search and found it as a very useful filter for list values. To use FORMULA types in a filter expression, such as, FORMULATEXT,...
Posts by Ryan
In Microsoft Word you can control whether or not you want to see the white space characters in your document. This helps to check you haven't incorrectly inserted a tab where a space should have gone...
Very similar to our previous article on how to make a header row in Google Sheets, in this article we'll show how you can lock a column in Google Sheets. To lock a column in Google Sheets easily...
I was recently working with a lot data on my Google Sheets spreadsheet and as I scrolled down the page the information from the top rows moved off and I could no longer see (and could no longer...
If you want to know how many words your Wordpress articles have you can open up each post individually and by clicking on the top left-hand corner’s information icon it will display the number of...
In a previous post I explored how to ignore blank cells when using the QUERY function in Google Sheets, which had its own distinct way of removing blank cells from the data capture. But how do...
