How do you add an empty row in HTML? To add an empty row in HTML for your table use the code <tr><td colspan=”X”> </td></tr> otherwise if you want to add an empty row without using a table use the <hr> tag. Here are some examples demonstrating how adding an empty row looks in your HTML …
How do you sort a list of lists by the second element using Python? To sort a list of lists by the second element in each list use the key parameter to either the .sort() list function (if modifying the original list) or the sorted() function (if returning a new list). Here’s an example demonstrating …
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 spreadsheet. Use this feature in Google Sheets if you find you …
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 following formula which helped to add the appropriate years, months or days to an existing …
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 sought. For example like this: Where default_value is the placeholder …
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 name of the field is creditholdoverride. To set the value for …
