Apologies as I am very new to airtable. Essentially, I have a column which contains a series of numbers which indicates how many businesses make it through a particular process. This number automatically updates based on my input in other areas of the table. What I would like to be able to do is have the success rate automatically update in the next row.
I can do it on excel, but with airtable being a database I am not sure how to go about doing this.
In excel it looks like this :
How can I do this in airtable?
The point of this is because I would like to then create a chart which keeps updating with this information, showing how many as a percentage make it through each stage.