How can I use a formula for the below data?

[Jake_Boggs]

Hi, so I am trying to make a formula that fits my gardening schedule for the upcoming spring season. I have the pro plan if that makes a difference in what I am limited to do. Here’s an live example of the problem I am having so far. I will plant my cilantro seeds on 3/22/23. It takes 4 weeks till harvest. So I have 4/12/2023 as the ending date. I will need two other harvest date’s after that. The problem is that I need formulas for each plant which is a total of 40. They all have different dates and different weeks till harvest. Would I need different formulas for an auto-fill each time I put seeds into the ground or am I able to create conditions for it to all work? Thanks.

[Mohamed_Swella1 · Accepted solution]

Hi @Jake_Boggs

What an interesting use of Airtable :grinning_face_with_big_eyes:

What you would need to do is have a table that is Plant (i.e.: it would have 40 records, 1 for each Plant). Then in this table, specify the harvest duration (you can express this in however unit you want as long as you stay consistent, i.e.: days, weeks, etc.)

Then in your Planting table, you would link the plants from the table you just created and use a Rollup field to bring the Harvest Duration in a new field. Using this new field, you can add a formula that is DATEADD({Start Date},{Harvest Duration},"days") (you would need to change the field names to your own fields)

Hope this helps :slightly_smiling_face:

[Jake_Boggs]

Yes, works awesome now! Thank you! YOU ARE THE BEST!!!