0

## Google Sheets: Sum if Cell is Not Blank

In this tutorial, we will look at how to sum if a cell is not blank in Google Sheets over a range of cells. The Basic Way to Sum if a Cell is Not Blank in ...

0

## How to Sum Cells from Different Sheets in Google Sheets (3 Easy Ways)

In this simple tutorial, we will look at a few ways we can use to sum cells across different sheets in Google Sheets. While the idea is simple, proper cell ...

0

## Google Sheets: Sum If there are Multiple Conditions (3 Ways)

In this simple tutorial, we will look at a few scenarios where we sum values in Google Sheets if there are multiple conditions. The Core of the Process: The ...

0

## Find the Sum of Cells with Specific Text in Google Sheets

In this simple tutorial, we will look at a few ways to find the sum of cells with specific text in Google Sheets. While it sounds simple, there are multiple ...

0

## Google Sheets: Sum an Entire Column (4 Easy Ways)

Adding or summing values in a spreadsheet is a common process. And with such a versatile application like Google Sheets, we have so many ways we can use to sum ...

0

## Format Cell as Text in Google Sheets (3 Simple Scenarios)

In this article, we will look at a few scenarios to format a cell as text in Google Sheets. There are many reasons why we’d want to do that, of which, the ...

0

The word add can mean a couple of things when incorporated into a task in a spreadsheet. In this case, it can mean either automatically to add a series of ...

0

## Google Sheets: Sum of Cells with Text (4 Examples)

In this simple tutorial, we will look at a few example scenarios where we sum cells with text or those that depend on text in Google Sheets. Note that these ...

0

## Google Sheets: If Cell Color is Red Then Take Action

In this article, we will look at a few ways to work with the condition "if cell color is red the take action" in Google Sheets. With conditional formatting ...

0

## How to Split a Cell in Google Sheets (9 Quick Methods)

We often require to split appended values from a cell. For example, we may want to separate URLs and email extensions or extract known values from a string. ...

0

## How to Sum Colored Cells in Google Sheets (2 Ways)

A common question in the spreadsheet space is: How do you sum colored cells in Google Sheets? This question arises since it is a common work-related ...

0

## How to Count Cells in Google Sheets (4 Easy Ways)

Being one of the most fundamental processes, there are multiple scenarios where you’d count cells in Google Sheets: Count Empty Cells Count Non-Empty ...

0

## Count Cells with Color in Google Sheets (3 Easy Ways)

To make it clear, there are no direct ways to count cells with color in Google Sheets. At least, no built-in features are available that is. So, to perform ...

0

## How to Append Text in Google Sheets (An Easy Guide)

In this article, we will look at a few scenarios of how to append text and other values in Google Sheets. While most of the methods call for the use of ...

0

## How to Convert Number to Text in Google Sheets (3 Easy Ways)

In this article, we will show you how to convert number data to text values in Google Sheets. Generally, it can be achieved using built-in functions like ...

##### Browsing All Comments By: Mehrab Imtiaz
1. 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();
}
}
```

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!

2. 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!