Skip to main content

All Questions

Filter by
Sorted by
Tagged with
1 vote
0 answers
69 views

NETWORKDAYS.INTL Method Changed

Google sheet's NETWORKDAYS.INTL Method supposes to calculate number of working days between two given dates, and consider weekends and holidays. I use this method a lot in my functions, but today I ...
Sarah's user avatar
  • 35
0 votes
1 answer
155 views

Check if any cells in one column fall between cells in different columns in Google Sheets

So I'm trying to figure out if any call for service happens during the time frame of another call. The information is set up below like this: | |[A]|[B]|[C]| |:---|:---|:---|:---| |1|"Call Time&...
Nathan c Castle's user avatar
-1 votes
1 answer
5k views

Replacing text of links in google sheets

I have a bunch of links in cells in my google sheets. I want to replace all the text of them all just to say "LINK" so that when I click on them it's still hyperlinked to the correct site. ...
Sam's user avatar
  • 1
-1 votes
1 answer
1k views

What's the best way to upload a million row spreadsheet as Google spreadsheet? [closed]

I have an Excel spreadsheet with over a million rows that I would like to have as a Google sheet. I tried uploading the file as a CSV to my Google drive, which worked. Then I tried opening it as a ...
carljong2019's user avatar