User Posts: Mehrab Imtiaz
Today, we will look at a few ways we can count unique entries in Google Sheets. While the idea is simple, it also means that there can be multiple types of ...
Mehrab Imtiaz
Today we will look at a couple of ways to concatenate number and string in Google Sheets. We will also see some advanced examples based on combining what we ...
Separators, or more technically known as delimiters, are a crucial part of making concatenated values in spreadsheets more presentable. Today, we will look at ...
Concatenating values is one of the more fundamental tasks performed in a spreadsheet. Today, we will be specifically looking into how to concatenate strings in ...
Today we will look at a few ways to compare two columns for duplicates in Google Sheets. While the idea is simple, we can have multiple scenarios surrounding ...
Today we are going to specifically look at how to compare two columns using conditional formatting in Google Sheets. Let’s get started. 2 Scenarios ...
There are multiple ways of how you can put a date in Google Sheets and our target today is to cover all of these in one single article. We will be starting off ...
Working with dates is one of the more common tasks available for any spreadsheet user. However, many users of varying expertise still have certain confusion on ...
Working with dates is one of the core tasks that anyone does in a spreadsheet. And today, we will look specifically at how we can add months to a date in ...
Counting between dates is a common task for any spreadsheet user as dates tend to be one of the most important forms of data in any spreadsheet. However today ...
The Date and time are one of the more fundamental aspects of any professional report. Understanding that, finding and displaying the current date and time is ...
Unlike MS Excel, Google Sheets does not have a built-in AutoSum feature. But that doesn’t mean that summing in this application is slow or non-intuitive. In ...
Adding values under certain conditions is a common affair in Google Sheets. But one approach that can be used to simplify a condition is the checkbox. As such, ...
SUMIF is one of the fundamental functions of Google Sheets which also means that its application might vary. As such, today we will look at how we can apply ...
To perform conditional sum in Google Sheets is relatively easy. The primary approach is to combine the idea of the SUM and IF functions of the application. ...
- « Previous Page
- 1
- …
- 7
- 8
- 9
- 10
- 11
- …
- 14
- Next Page »
Hello,
If you want to specify which column’s changes will trigger the timestamp, all you have to do is include an IF ELSE statement inside the existing one. For example, let’s say that the SL column is Column A in the sheet:
if(sheetName == 'Stock'){ if(range.getColumn() !== 1) return else{ var new_date = new Date(); spreadSheet.getActiveSheet().getRange(row,4).setValue(new_date).setNumberFormat("MM/dd/yyyy hh:mm:ss"); } }So, if changes are made to any column other than column A or 1, no timestamps will be triggered.
For multiple triggers, we recommend different scripts for each.
I hope it helps!
Hi Max,
I am assuming that you are thinking about extracting the letters ABC from ABC-123. In this case, you can approach it in two ways without even using wildcards.
The first way is to use text functions to extract the number of characters from the string:
=LEFT(B2,LEN(B2)-4)
The LEN(B2)-4 removes the last 4 characters from the string.
For a more dynamic approach, you can look for the hyphen/dash as a delimiter to remove characters before or after it. In this case, to get ABC from ABC-123, the formula will be:
=MID(B2,1,FIND(“-“,B2)-1)
Just replace “-” with any delimiter of your choosing.
However, if you still want to extract using regular expression to get ABC from ABC-123, use this:
=REGEXREPLACE(B2,”[0-9-]”,””)
The regular expression to remove all digits and hyphens is given by [0-9-].
I hope this helps!