Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 15, 2021 08:38 AM
Hi There,
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.
Thanks
L
Nov 15, 2021 10:22 AM
Hi L! With the formula field, you’ll be able to make that happen. A lot of the formulas work exactly as or very similar to Excel. Just select formula as the field type and calculate the success rate. Let me know if you need further help with this!
Nov 15, 2021 10:52 AM
Hi,
This topic may help you
I think, in your case, you can use “link to the same table” feature, creating new linked field and copy-pasting sorted primary field to new linked, but one step down (i.e. Step2 will be linked to step1, Step3 - to step2 etc…). But that depends on how often you change the number of steps