
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 19, 2021 04:45 PM
Hi, all. I have a table that has a “Planting Date” for a vegetable field. This record is linked to another table that contains the number of growing days (ex: 90 days). I’d like to use a formula that would take the planting date plus the number of growing days (90) and give me an anticipated harvest date. What’s the right formula?
By the way, each week has a different “grow days” associated with it so hard coding 90 days into the formula won’t work.
Thanks,
Paul
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 20, 2021 06:52 AM
It looks like your DTH is a linked record field. You need to have a rollup field that is based on the linked record field.
It also looks like you store numbers in single line text fields, as in the {Act Acres} field. Make sure the field where you are storing the DTH is a number field. (Because that field is in another table I cannot see it’s field type in this screen capture.)
It is important to have the correct field types or the formulas will not work.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 19, 2021 08:11 PM
Welcome to the Airtable community!
- Create a {Growing Days} rollup field (not a lookup field) to get the number of {growing days} from the linked record. If there is only one linked record, you can use any of the mathy rollup formulas, such as
SUM(values)
. - Use the
DATEADD()
function to add the number of days in the {Growing Days} rollup.
DATEADD({Planting Date}, {Growing Days}, 'days')
This assumes that your {Growing Days} field is a number of days. If this doesn’t work, please share screen captures of your setup so we can see what else might be going on in your base.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 20, 2021 06:43 AM
Thank you. I believe a screenshot will help. I am attempting to get a harvest date by adding the DTH (days to harvest) to the planting date.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 20, 2021 06:52 AM
It looks like your DTH is a linked record field. You need to have a rollup field that is based on the linked record field.
It also looks like you store numbers in single line text fields, as in the {Act Acres} field. Make sure the field where you are storing the DTH is a number field. (Because that field is in another table I cannot see it’s field type in this screen capture.)
It is important to have the correct field types or the formulas will not work.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 20, 2021 07:55 AM
Thank you. Your advice worked perfectly.
