Categories
User Help Web Apps

Gmail snooze until 7 days (one week)?

Is it possible to define a Gmail snooze until 7 days, in addition to the default ones being Later Today, Tomorrow, This Weekend, Next week?

Categories
User Help Web Apps

Query a column based on current date

I’m trying to query a column based on the current day. Examples: If today is 1st day of the month I need to: =QUERY(table,”SELECT A WHERE B CONTAINS ‘this text'”) If today is 12th day of the month I need to: =QUERY(table,”SELECT A WHERE M CONTAINS ‘this text'”) If today is 30th day of the […]

Categories
User Help Web Apps

How to get a new date when calculating from today plus an integer

I use Google Sheets to calculate my word count & rate for daily writing sessions. I’m trying to come up with a formula that will return the estimated date of hitting a goal, based on my current rate. For further explanation, my monthly goal is 10,000 words. I enter my daily word count into a […]

Categories
User Help Web Apps

Google Sheet highlight differing words when comparing two cells (both contain text words)

How to write Google script so that we can highlight differing words when comparing two cells (both contain text word strings)? Basically script version of the VBA code here: How can I compare two columns in Excel to highlight words that don’t match?

Categories
User Help Web Apps

Google Sheet highlight differing words when comparing two cells (both contain text words)

How to write Google script so that we can highlight differing words when comparing two cells (both contain text word strings)? Basically script version of the VBA code here: How can I compare two columns in Excel to highlight words that don’t match?

Categories
User Help Web Apps

Google Sheet highlight differing words when comparing two cells (both contain text words)

How to write Google script so that we can highlight differing words when comparing two cells (both contain text word strings)? Basically script version of the VBA code here: How can I compare two columns in Excel to highlight words that don’t match?

Categories
User Help Web Apps

How to check how two or three values relate over time

Do you think is possible to build a sheet with 3 variables(A,B,C each in a column) and say a set of 1000 values(1000 rows)? And have a way to produce a report on how they relate over time? I’m interested to have some cell at the end of the row telling me A B and […]

Categories
User Help Web Apps

Improve contrast of current item in slides

I was watching this video. The speaker mentioned a feature in power-point, where you can highlight the current item in a list (by dimming all other items). How can I do this (easily) in Google Slides?

Categories
User Help Web Apps

Google Sheet highlight differing words when comparing two cells (both contain text words)

How to write Google script so that we can highlight differing words when comparing two cells (both contain text word strings)? Basically script version of the VBA code here: How can I compare two columns in Excel to highlight words that don’t match?

Categories
User Help Web Apps

Copy entire rows from one sheet to another if certain cell in first sheet does NOT contain certain text value

I have two sheets. The first one has incoming data that dynamically updates. The fields are Name, Last Name, Email. I want to duplicate the rows in a second sheet but only if the email field in sheet 1 does NOT end with or contain “@gmail.com”. Any idea on how can I accomplish this?