What is a named function in Google Sheets and when is it best to use this new feature in your spreadsheet? Google Sheets new Named Functions feature enables you to refactor long formulas into what appears as a native function in your Google Sheets … [Read more...] about Google Sheets Named Functions In 5 Minutes
Blog
Google Sheets SWITCH Formula Example: Refactor IF Functions By 20%
How do you use the Google Sheets SWITCH() formula? The SWITCH() formula in Google Sheets enables you to compress a series of IF statements, even nested IF statements, into one succinct function. Take a recent example where I refactored the … [Read more...] about Google Sheets SWITCH Formula Example: Refactor IF Functions By 20%
How To Set A Default Value For VLOOKUP
How can you set a default value when using the VLOOKUP function? As VLOOKUP throws an #N/A error when the searched item cannot be found in the first column range, wrap the VLOOKUP function in an IFERROR formula and set the value to the default … [Read more...] about How To Set A Default Value For VLOOKUP
SuiteScript Change On Credit Hold Field On Customer Record
How do you change the Hold field found on the customer record using SuiteScript? The Hold field in a Customer record prevents users or the customer from having any new Sales Orders being placed and has three settings On, Off and Auto. The code … [Read more...] about SuiteScript Change On Credit Hold Field On Customer Record
How To Create A Radio Button In Suitelet Form
How do you create a radio button in a Suitelet form? To create a series of radio button elements in a Suitelet form you need to add each element of the radio series as distinct fields using the .addField function. The id property needs to be the … [Read more...] about How To Create A Radio Button In Suitelet Form
How To Remove \n From String In Python
How do you remove a newline character \n from a string in Python? The easiest way to remove a new line from a string in Python is by using the string method .replace(). Another way is to use the string method .strip() if the new line is at the … [Read more...] about How To Remove \n From String In Python