User Posts: Mehrab Imtiaz
In a practical scenario, you will often have huge amounts of data in your spreadsheets. In such a situation finding certain text in this huge database can be a ...
Mehrab Imtiaz
It is more than likely that a workbook or spreadsheet may have multiple worksheets with various data organized and spread across it. It is also possible that ...
A veteran in Excel will tell you how powerful the COUNTIF function and all its iterations are. The same importance is carried over to Google Sheets. In this ...
When working with spreadsheets there will come a time when you will need to count duplicates in your data, whether it be for extraction or removal. In this ...
The ability to highlight duplicates in any worksheet is crucial for a variety of reasons. While it may sound easy to do, it can prove to be very complex if you ...
Any type of formatting based on cell values or conditions can be easily done by the Conditional Formatting option of Google Sheets. To show you how to ...
Contrary to popular belief, barring certain confusing aspects of spreadsheets, how to reference another workbook in Google Sheets is fairly simple. We are ...
No matter how much of an expert you are, many still sometimes find it difficult to extract data from one worksheet to another. Exponentially so when conditions ...
One of the problems that many bookkeepers, financiers, or anyone who works with worksheets will have in common is the understanding and the application of ...
Inserting rows may sound like a pretty straightforward task, but one wrong move or one wrong click on your precious worksheet may end up in disaster. So ...
Access and collaboration are two of the main driving forces behind Google Sheets and the other applications in the line. As easy as it can be to share your ...
Merging cells in a spreadsheet is one of the more fundamental skills to have. But things might get complex when certain patterns of merges are involved. So ...
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!