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.
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.
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.
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.
Thank you. Your advice worked perfectly.