Skip to main content
Solved

Increase according to month and automatic calculation

B

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!

Best answer by Kamille_Parks11

Blending_Produc wrote:

Great!! The formulas worked perfectly for what I needed, I’m enjoying the airtable even more now!

Thank you very much for your attention and help!

If not asking too much, could you help me with one more question?

I would like to know how I can multiply a result according to the responses of a “Unique Selection Field”. For example: Total Value = Unit Value * {Unique Selection Field}

I believe that for that I would have to create a column of reference and hide it there later, right? So I could follow the same logic you showed me.

Thanks in advance!


Multiplication would be fairly straightforward

{Unit Value} * 
SWITCH(
{Unique Selection Field},
"green", 1,
"purple", 1,
"black", 0.5
)
View original
Did this topic help you find an answer to your question?

5 replies

Kamille_Parks11
Forum|alt.badge.img+15

Assuming you have a {Start Date} field, where for the given example the start date was 12/22/2021, then a formula could be:

DATETIME_DIFF(
{Start Date},
TODAY(),
"months"
)

SWITCH(
{Unique Selection Field},
"green", 1,
"purple", 1,
"black", 0.5
)
B
1 person likes this
  • B
    Blending_Produc
B
  • Blending_Produc
  • Author
  • Known Participant
  • 17 replies
  • December 6, 2021
Kamille_Parks11 wrote:

Assuming you have a {Start Date} field, where for the given example the start date was 12/22/2021, then a formula could be:

DATETIME_DIFF(
{Start Date},
TODAY(),
"months"
)

SWITCH(
{Unique Selection Field},
"green", 1,
"purple", 1,
"black", 0.5
)

Great!! The formulas worked perfectly for what I needed, I’m enjoying the airtable even more now!

Thank you very much for your attention and help!

If not asking too much, could you help me with one more question?

I would like to know how I can multiply a result according to the responses of a “Unique Selection Field”. For example: Total Value = Unit Value * {Unique Selection Field}

I believe that for that I would have to create a column of reference and hide it there later, right? So I could follow the same logic you showed me.

Thanks in advance!

Kamille_Parks11
Forum|alt.badge.img+15
Blending_Produc wrote:

Great!! The formulas worked perfectly for what I needed, I’m enjoying the airtable even more now!

Thank you very much for your attention and help!

If not asking too much, could you help me with one more question?

I would like to know how I can multiply a result according to the responses of a “Unique Selection Field”. For example: Total Value = Unit Value * {Unique Selection Field}

I believe that for that I would have to create a column of reference and hide it there later, right? So I could follow the same logic you showed me.

Thanks in advance!


Multiplication would be fairly straightforward

{Unit Value} * 
SWITCH(
{Unique Selection Field},
"green", 1,
"purple", 1,
"black", 0.5
)
B
1 person likes this
  • B
    Blending_Produc
B
  • Blending_Produc
  • Author
  • Known Participant
  • 17 replies
  • December 6, 2021
Kamille_Parks11 wrote:

Multiplication would be fairly straightforward

{Unit Value} * 
SWITCH(
{Unique Selection Field},
"green", 1,
"purple", 1,
"black", 0.5
)

Perfect!! It worked great too!
Again, thank you so much for your patience and time, it helped me a lot.

Until later!

Kamille_Parks11
1 person likes this
  • Kamille_Parks11
    Kamille_Parks11
bootsyart
  • bootsyart
  • New Participant
  • 1 reply
  • December 18, 2023
Kamille_Parks11 wrote:

Assuming you have a {Start Date} field, where for the given example the start date was 12/22/2021, then a formula could be:

DATETIME_DIFF(
{Start Date},
TODAY(),
"months"
)

SWITCH(
{Unique Selection Field},
"green", 1,
"purple", 1,
"black", 0.5
)

This formula is amazing, I'm using it to automatically increase the total rent paid every month. One problem, the automatic monthly increase doesn't increase till the final day of the 30 days/month. I wish it would increase at the first of every month. Any ideas?

2 Attachments

Reply


Most helpful members this week

Terms & Conditions