
Kasey Morris
Member
Members

Forum Posts: 7
Member Since:
April 6, 2022
April 6, 2022


Mynda Treacy
Admin

Forum Posts: 4614
Member Since:
July 16, 2010
July 16, 2010

Hi Kasey,
Your spreadsheet should have 3 columns:
- Plant Type (tomato, beans, corn etc.)
- Task (sow, plant, harvest)
- Month (enter proper dates e.g. 1/1/2024, 2/1/2023 assuming mm/dd/yyyy format)
Each plant will have three rows in the table, for sow, plant and harvest.
You can then use PivotTables and Slicers to plot the data in the format shown on the packaging with months across the columns and tasks down the rows. You can insert a Slicer for the Task and Dates (grouped by months) to filter the PivotTable.
I hope that points you in the right direction.
Mynda

Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Susan VanRiper, Pedro Llobell, Lorna Henning, Joaquim Amorim, Nikita Bhatia
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
David von Kleek
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Ashley Hughes
Herbie Key
Trevor Pindling
Forum Stats:
Groups: 3
Forums: 24
Topics: 6528
Posts: 28594
Member Stats:
Guest Posters: 49
Members: 32817
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
