All Things Gardening forum: Google spreadsheet tip

Views: 418, Replies: 3 » Jump to the end
Name: Frank Richards
Clinton, Michigan

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 Celebrating Gardening: 2015 I was one of the first 300 contributors to the plant database! I helped beta test the first seed swap Garden Sages Region: United States of America
Region: Michigan Seed Starter Vegetable Grower Greenhouse Birds Butterflies
Oct 30, 2014 8:00 AM CST
Frank, you are the spreadsheet guru !! Thumbs up
"Blessed is he who has learned to laugh at himself, for he shall never cease to be entertained."
- John Powell / - A Universe of Communities
/ 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.

Today's site banner is by Paul2032 and is called "Iris Dazzling"