The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

# Think I need a simple formula

Topic Labels: Formulas
Solved
1283 2
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

I think this can be done, might just need to add a new field!

On table ‘seed packets’, I have a manual number field to log how many seeds in the original packet. On table ‘sowing log’ it calulates how many seeds I have sown by N numbers in N numbers of stations (manually logged, auto answer (I didn’t set it up so language may be wrong).

On the ‘seed packets’ table I appreciate I shall need to create a new field for the answer. I want it to take off the number of seeds sown from the original packet number

I am familer with formulas in excel but not here so please, if someone could give me a simple starter I’d be most grateful; or correct me if I am heading down the wrong path

1 Solution

Accepted Solutions
5 - Automation Enthusiast

Thank you very much, first formula done :grinning_face_with_smiling_eyes: Both linked together so easy lookup. Created field to look up total seeds sown and could pick field for original seeds and minus the new seeds sown field (explaining incase it helps others).

This will change for me in time as I need a total sowing log, not just this year but I now feel confident to do it

Much appreciated.

2 Replies 2
18 - Pluto

Are the [seed packets] and [sowing log] linked together?

It sounds like you need two new fields

• a lookup or rollup field to pull the information from the [sowing log] into [seed packets]
• a formula field to do the calculation

I find the formula field reference very helpful. It has lots of examples.

5 - Automation Enthusiast

Thank you very much, first formula done :grinning_face_with_smiling_eyes: Both linked together so easy lookup. Created field to look up total seeds sown and could pick field for original seeds and minus the new seeds sown field (explaining incase it helps others).

This will change for me in time as I need a total sowing log, not just this year but I now feel confident to do it

Much appreciated.