Help

Think I need a simple formula

Topic Labels: Formulas
Solved
Jump to Solution
994 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Deborah_Clark
5 - Automation Enthusiast
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
Deborah_Clark
5 - Automation Enthusiast
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.

See Solution in Thread

2 Replies 2

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.

Deborah_Clark
5 - Automation Enthusiast
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.