All Things Gardening forum: Google spreadsheet tip

Views: 577, Replies: 3 » Jump to the end
Name: Frank Richards
Clinton, Michigan (Zone 5b)

Garden Ideas: Master Level Celebrating Gardening: 2015 Plant Identifier
Oct 28, 2014 12:20 PM CST
If you use a google spreadsheet for keeping track of your plants, here is a hyperlink that you can use to search the APT database.

=HYPERLINK(""&(Substitute(SUBSTITUTE(B332," ","+"),"'","")),"ATP")

In my sheet, cell B332 is the Binomial nomenclature of the plant, genus species 'cultivar'

For example Cornus alba 'Elegantissima' or Dahlia 'A La Mode'

Clicking on this hyperlink in your spreadsheet will bring up the ATP database page of the plant in question.

I find it very handy.

Name: Arlene
Grantville, GA (Zone 8a)
Greenhouse Region: Georgia Garden Sages Organic Gardener Beekeeper Vegetable Grower
Seed Starter Cut Flowers Composter Keeper of Poultry Keeps Goats Avid Green Pages Reviewer
Oct 29, 2014 7:54 PM CST
If only I could get that organized to enter them...
Name: Judy
Simpsonville SC (Zone 7b)
Plant and/or Seed Trader Peonies Garden Ideas: Level 1 Celebrating Gardening: 2015 I helped beta test the first seed swap
Oct 29, 2014 8:43 PM CST
If only I knew how to use a hyperlink. Lol *Blush*
Name: Sandy B.
Ford River, Michigan UP (Zone 4b)
(Zone 4b-maybe 5a)
Charter ATP Member I was one of the first 300 contributors to the plant database! Garden Sages Million Pollinator Garden Challenge Seed Starter Vegetable Grower
Greenhouse Region: United States of America Region: Michigan Enjoys or suffers cold winters Butterflies Birds
Oct 30, 2014 8:00 AM CST
Frank, you are the spreadsheet guru !! Thumbs up
“Think occasionally of the suffering of which you spare yourself the sight." ~ Albert Schweitzer / - A Universe of Communities[/I] / Share your recipes: Favorite Recipes A-Z cubit
C/F temp conversion / NGA Member Map

« Homepage
« Back to the top
« Forums List
« All Things Gardening forum
You must first create a username and login before you can reply to this thread.

Member Login:



[ Join now ]

Today's site banner is by plantmanager and is called "Adenium Obesum"