User Posts: Mehrab Imtiaz
Dates in Google Sheets are stored as integers, making it quite easy to use them for various calculations. And one of these calculations could be to find if a ...
Mehrab Imtiaz
Today we will see how to find and use the condition of if date is before today in Google Sheets. Date calculations are quite common in Google Sheets, ...
In this simple tutorial, we will look at how we can use today’s date in Google Sheets for different date calculations. We will start with some basic ...
The FIND function comes in handy when you want to search for a keyword with a piece of text or string. And with enough understanding and creativity, we can ...
When we think about deleting anything from a spreadsheet, we think about deleting the contents of an entire cell. But sometimes we might need to remove partial ...
Google Sheets is an application powerful enough to recognize most values and patterns in its spreadsheets, making it that much easier to search for ...
Wildcards can be a staple when it comes to customizing searches in any Google workplace application. So today, we will answer a few questions and discuss a few ...
Today we have a look at a couple of different ways by which we can replace space with a dash in Google Sheets. One method talks about direct replacement, and ...
In this simple tutorial, we will show you how you can find all cells with value in Google Sheets. Be it any value or specific value (text or otherwise) that ...
Today, we have a look at how we can find a value in a range in Google Sheets. The idea is simple, and we have a few approaches in mind that we can use ...
Today, we have a look at a few ways we can use to compare text in Google Sheets. Let’s get started. 3 Ways to Compare Text in Google Sheets 1. Using the ...
Printing can be easy in a word document file where the page layout is mostly the same as the page you will be printing. But the scenario is completely ...
Unlike MS Excel, Google Sheets provides its users with only 26 columns (A-Z) to work with off the bat. While this amount is more than enough for the average ...
Today, we have for you a simple guide explaining how to insert a textbox in Google Sheets. We dive into the nitty-gritty of the “whys” on top of the “hows” as ...
Knowing how to perform a character count in Google Sheets can often come in handy in many situations. And today we will look at some of these scenarios and ...
- « Previous Page
- 1
- …
- 6
- 7
- 8
- 9
- 10
- …
- 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!