User Posts: Mehrab Imtiaz
The Custom Number Format feature of Google Sheets serves to add additional formatting rules to number values in the application. These formatting rules are ...
Mehrab Imtiaz
In this article, we will look at how we can format cells to fit text and other values in Google Sheets automatically. But first, let’s understand the ...
In this article, we will look at how to use the VALUE function in Google Sheets. It is one of the simplest functions available in the application and its ...
In this article, we will look at how we can format the cell size in Google Sheets with examples following some basic scenarios. When you open a Google ...
This article will look at how to convert any value to a number in Google Sheets. There are many ways to do so, from formatting the cell to utilizing ...
Google Sheets has multiple ways to convert a string to a number. It can be as easy as using built-in functions or features of the applications or going deeper ...
This article will look at how to convert time to a number value in Google Sheets. It can be in hours, minutes, or seconds in decimal form. Fundamentally, ...
While Google Sheets has a few default number format options to change to, it is only scratching the surface of its capabilities. The application allows the ...
In this article, we will show you how to add and format currency values in Google Sheets. Currency is just another numerical value that conveys a different ...
In this article, we will show how to convert a text value with a number value in Google Sheets. Knowing how a value is formatted is quite important when ...
To format a number with a formula in Google Sheets can be crucial as many users can have different requirements and formatting styles in mind. These small but ...
Working with numbers in a spreadsheet can be quite tricky especially when we want to customize them to our requirements. In these cases, it can be a good idea ...
It can be crucial to add commas to numbers in Google Sheets in the correct position to convey the meaning behind the digits. Whether it be a currency, ...
Unlike MS Excel, Google Sheets allows the use of regular expressions to find and directly work with alphanumeric values from a cell, of course with specific ...
It is a given that most official spreadsheets contain a lot of data and in turn contain a lot of formulas. The thing is, having a lot of compound formulas like ...
- « Previous Page
- 1
- 2
- 3
- 4
- …
- 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!