$# : Number of arguments passed via script

$0 : Name of the script

$@ : Names of arguments passed to the script at execution

$$ : Process ID associated with script

$OSTYPE : What’s the OS type?

$TERM :  What’s term is being used?

$USER : What’s the username that executed the script?

$HOSTNAME : What’s the hostname of the box that ran the script?

$LOGNAME :  What was the login username?

$LINENO : Current line # of the script

$RANDOM : Random #

$BASH_SOURCE :  What’s the bash source?

Example script:

 

 

 

 

This will create a folder for each month 01-12.  Inside each month folder will be 30 or 31 folders for each day of the month except for Feb. which will have only 28.  This can be changed to 29 if it happens to be a leap-year.

 

 

Data coming from different spreadsheet.

B25 = local cell which you are using for the search
URL = url from separate google sheet
sheet1 = name of other sheet your pulling data from
!a1:e = range of the search
After the search
3 = which column you wish to pull the data from
false = will your results be sorted?

If you get #REF when you first try this, just click your mouse on that and it will bring up a “allow access” dialog. You need to allow access if your pulling data from another spreadsheet.

Here’s how to locally pull data from another sheet.  For example, you have a sheet1 and sheet2.

B3 = cell you want to use for search

Sheet2 = Sheet your pulling data from

!C3:E3 = range you want to pull data from

3 = which column you want data from

false = results will not be sorted.