Jim Farrell

Member since 5/22/2019

Achievements

To start earning badges, sign up to be a Product Expert in our Product Expert Program .

Activity

No recent activity

Post history

Google Maps•2/1/2021

The gorilla in the room while using {Microsoft} Windows 10 insists on using Bing Maps. I want to use Google Maps by Default, instead. Is there a way to tranquilize this gorilla enough to reach this goal?

24 upvotes

1 reply

How do you enable a custom function to dynamically change it's value?

Google Docs Editors•6/18/2020

Earlier I had posted a question about including a sheet's name in a cell(s). I've found my answer (

Sheet Name Function) only to learn that it only captures the name of the Sheet at the time I invoke the function. When I change the name of the Sheet, the result in the cell that I invoke my custom function remains the same as I first described. Is there a way to the modify the function so it always reflects the current name of the Sheet?

1 upvote

1 reply

Reply to Get current sheet name in cell

Google Docs Editors•11/6/2019

I'm having the difficult (Using Edge) to include the UTIL_SHEETNAME() add-on. I just get a blank popup. Is it a part of Google Sheets of standard functions? How do I access the script I created using the script editor?

What are the logical operators accepted by Google Sheets?

Google Docs Editors•10/28/2019

I'm trying to arrive at a single result based upon a single value. The possible results are within a table of ranges. My place to begin is a SWITCH function where individual cases contain an AND statement which reflects that within a given range, the acceptable result is based upon the value being within that range.

For example . . . lower is equal to or greater than itself and can be less than or equal to the highest end of the range. Is there a way to express a single character, within a function that is the same as >= OR <=?

30 upvotes

1 reply

Reply to Extensions do not show in menu bar. How do I fix this?

Google Chrome•5/22/2019

Apparently, I want too many extentions. I can find the ones that I want to use and I find the ones that could quietly run in background. Firefox has a drop down box where the add-tons can be customized, where is the simular control for Chrome?