Hello guys!
I’m new here and I’m still learning about Airtable, but I’m really enjoying it!
I have some doubts about formulas, I would be very happy if they work for what I need, here are my doubts:
1 - Is there any way to add numbers in a column automatically every time you turn the month? For example: Column “parcels” on 12/22/2021 = 1 on 01/22/2022 = 2 and so on?
This would be very useful because here in Brazil we make purchases in installments, so the number of installments, changing month by month alone, would make it much easier.
2 - Is there any way for the formulas to understand the “unique selection fields”?
I would like to create a formula like: If the “unique selection field” has the option “green” the answer is 1, if it has the option “purple” the answer is also 1, but if it has the option "black " the answer is “1/2”
Thanks in advance!