Merge multi-columned data to one column before expanding it out into a different columned layout using the QUERY and ARRAYFORMULA functions in Google Sheets.
How do you calculate the sum of values across columns when the length of the range of those columns is dynamic? Use the INDEX function, as demonstrated in this post.
If you’ve done work from the Google App Script Editor, but need that extra development environment to help you code, then there’s a great module you can install from npm that will help you edit and push your edits from your computer to your Google App Script code in the cloud. This has the added benefit of also being able to apply git to your code if you need to push your code to your organisation’s repository.
The Advanced Template in NetSuite throws an error on a line that contains no data in my text editor – what’s going on?
How do you force a page break in your Advanced PDF/HTML template to print content on another page?
How can you easily check if a Google Sheet cell has a value, and if it doesn’t to set a default value when assigning it to a variable in Google App Script?
If you want to aggregate your CASE results in a NetSuite Saved Search then you easily do so by applying the SUM grouping function to your Formula. Here’s an example illustrating aggregation and nested CASE statements.
If you’re left scratching your head in constructing NetSuite reports, then you’re not alone. Here are a couple of tips that may help guide you in completing that reporting task.
How can you apply a conditional statement on your results in a NetSuite Saved Search Formula? We explore the DECODE and CASE conditionals and why you would choose one over the other.
How do you loop through lists in NetSuite’s Advanced Template? In this guide we’ll explore how you can loop through a list and how you can appropriately check the elements within your list exist.