Newbie here working on building a crop plan for my homestead, but don't think i'm setting this up correctly in Smartsheet.
So far, I've got a sheet called "crop info". This has stuff for my main crop list so
name of crop, weeks in greenhouse, number of plantings, etc. This is kind of like my more general goals for the season.
I've also got a secondary sheet called "crop plan" which is where I will schedule my crops. This is where i will put the specific details of each crop like varieties. Right now, I've got the list of crops in a dropdown list. (because I don't think you can use values of one sheet in a dropdown list). That's fine.
So this sheet has variety, name of crop (dropdown list), days to maturity, start date, end date, etc.)
What I want is to also be able to pull data from crop info into crop plan so I can calculate things instead of doing each calculation manually. So if I select lettuce in the crop plan, it will also be able to calculate how long in the greenhouse lettuce takes.
The problem is when i am in "crop plan", I go to link to "crop info" and that sheet does not show up? I am thinking something is wrong with my workspace or I don't understand the difference between a workspace or a sheet? I can see the sheets in "recents" just not when i use the link?
