I am submitting our Content for an award competetion, so submissions fees differ.
1st Submission is : 400
2nd Submission and up are: 210 Each
1st submission is: 400$
2nd Submission is: 120$
3rd and up is: 60$ each
How can I create a formula read the 1st, 2nd, 3rd, and so on and add the right fees amount through a formula? or a rollup? Some help is needed here Guys, appreciate your time.
Thanks, A lot
Adam from Airtable here.
I made a short video for you here: Screen Recording 2021-05-06...
Additionally, here’s a link to the formula field reference support article as well as the formula I used:
Hope that helps you gather some ideas~~
Thanks, A lot @Adam_Minich, That exactly what I was looking for, Appreciate you took the time and record something for me, I was not thinking at all about the Linked records count, which indicates what to expect from a well-set formula, I will give it a try, I think it will work. Thanks again mate
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.
Happy to help! Have a fantastic day.