Conditional Formatting With Custom Formula Using Relative References

How can you apply conditional formatting using a custom formula that contains a relative reference to an adjacent row or column in Google Sheets? If you want to highlight a cell in Google Sheets using conditional formatting based on the condition of a nearby cell you can easily do so by using the Custom Formula feature along with the INDIRECT() formula that contains a relative reference. The INDIRECT(cell_reference, is_A1_notation) formula in Google Sheets contains two parameters with the first parameter being a string representing the specific cell reference either as a named range (i.e. salesTax), or an absolute reference known by the common A1 notation with column letter followed by the row number (i.e. A1). The second parameter to the INDIRECT formula is_A1_notation is by default set to TRUE, therefore, when using a relative reference this parameter needs to be set to FALSE. ...

June 2, 2022 · 8 min · 1559 words · Ryan Sheehy

Add Button To Record Using Client Script And User Event Script: SuiteScript

How can you add a button to a record in NetSuite that can be used to trigger a process regardless of whether the record is being viewed or edited? Creating a button on a client script does have the problem where it can only be accessed when the record is in EDIT mode which doesn’t help when you want to trigger a process when the record is in VIEW mode. ...

June 1, 2022 · 7 min · 1314 words · Ryan Sheehy

Google Sheets Multi Select Dropdown List

Can a Google Sheets drop-down list in a cell allow you to do multiple select? Google Sheets doesn’t natively support the ability to select more than one item on a drop-down list in a cell, but there is a way where you can click an item in the drop-down list and have the clicked item populate the active cell. Here’s an example of what this would look like: Create Your Drop Down List First, create your drop-down list of items by selecting the cell, or range of cells, where the drop-down list will be available. ...

May 31, 2022 · 11 min · 2276 words · Ryan Sheehy

NetSuite RESTlet Example (OAuth1): Send File Using Python

How do you send a file through to your NetSuite instance via a RESTlet using a Python Script? If you know how to send a POST request through to a RESTlet using Python then only minor modifications need to be made to enable the sending of a file. One reason why you may prefer sending a file for NetSuite process is where you have a lot of data to consume and would prefer sending the consumption of the data through a Map/Reduce script. The RESTlet would then be responsible for capturing the data files, and then triggering the Map/Reduce script to process the data. ...

May 11, 2022 · 8 min · 1630 words · Ryan Sheehy

NetSuite RESTlet Example (OAuth1): Python Script To RESTlet

How do you send data to your NetSuite RESTlet using Python? To send data to your NetSuite RESTlet using Python code utilise the handy requests_oauthlib library. If you need to upload a series of CSV files and want to perform some data cleaning before being uploaded and want to avoid the Import CSV process then you can create a simple RESTlet and insert your clean data directly. Create Your RESTlet First, create your RESTlet and make it perform the basic tasks needed to import the data you want. ...

May 10, 2022 · 7 min · 1347 words · Ryan Sheehy

How To Remove Trailing Slash In Python

How do you remove a trailing slash in a string using Python? There are two popular ways to remove a trailing slash from a string in Python. The most common approach is to use the .rstrip() string method which will remove all consecutive trailing slashes at the end of a string. If you only need to remove one trailing slash the string slice operator can be another alternative. Here’s how each approach works. ...

April 20, 2022 · 3 min · 539 words · Ryan Sheehy

How To Make An Email Address Clickable In Excel

How do you make an email address in an Excel spreadsheet clickable? To make an email address clickable in a spreadsheet check the format of the cell is not set to text, if not when entering an email address Excel should automatically detect that it is an email address and add the mailto: hyperlink automatically. If after checking the cell is not set to Text and even after entering a valid email address Excel isn’t converting the entry to a hyperlinked mailto: address you can get Excel to force the cell to be a hyperlink using the HYPERLINK() function. ...

March 31, 2022 · 3 min · 447 words · Ryan Sheehy

Python Int Function: How It Works And Why You May Need To Create Your Own

How does the int() function work I. Python and could you write your own function? The int(x, base=10) function in Python takes two parameters: the first parameter x being either a number or string and the second representing the base number to return (10 being default which represents the decimal number system) and converts x into a whole integer number. A simple example of converting a string is demonstrated below: ...

March 29, 2022 · 7 min · 1440 words · Ryan Sheehy

How To Read File Into List With 1 Line Of Code In Python

How do read the contents of a file in Python and insert these lines into a list? Using the built-in function open() and the asterisk operator * a file’s contents can easily be translated into a list with the following one-liner: [*open('my_file.txt')]. What Does open() Function Do? The built-in open() function has one required parameter and several optional parameters. The required parameter is the location of the file. If the file is located in the current folder where the Python script is run you can insert the name of the file, for example, test.txt. ...

March 28, 2022 · 6 min · 1177 words · Ryan Sheehy

How To Prepend List With A New Value Or Contents Of Another List In Python

How do you prepend a value or item to a list? Or how do you prepend the contents of a list to another list using Python? There are two ways to prepend items to an existing list in Python: for single items use the list method .insert(idx, value) – this method will mutate the original list, or use the list concatenation operator new_list + old_list which can be set to a new variable and prevent the original list being mutated. ...

March 28, 2022 · 5 min · 902 words · Ryan Sheehy