Skip to main content

Hello Everyone,


I am submitting our Content for an award competetion, so submissions fees differ.

1st Submission is : 400
2nd Submission and up are: 210 Each


another competition

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

Hi @Ahmed_Elagami,


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:


IF({Count submissions}=1, 

 400, 

  IF({Count submissions}=2,

   520,

    IF({Count submissions}>=3,

    520+(60*({Count submissions}-2))

        ) 

      )

    )

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

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


Happy to help! Have a fantastic day. 🙂

Reply


Terms & Conditions