Tiaan_Terblanch - profile

Tiaan_Terblanch · May 29, 2023

Good Day,We added a CSV file with all our invoice amounts, and we have also added a CSV with all our credit notes.Is there a formula that will automatically deduct the credit note amount from the invoice amount based on the Document Type column?So I ...

Tiaan_Terblanch · May 10, 2023

Hi, we are importing data with a CSV and have a few fields with currency.On the CSV, the amount reflects in the following example:397,00 €, but when we import it, Airtable changes it to; €39,7000,97 €, but when we import it, Airtable changes it to; €...

Tiaan_Terblanch · Dec 05, 2022

HiI would appreciate any assistance with my formula.The end goal is that my Cost field should automatically calculate a cost based on a combination of options selected from the Frequency, Activity, and Complex fields.The dropdown options for Frequenc...

Tiaan_Terblanch · Oct 14, 2022

Hi We would really appreciate some assistance with one of our formula fields. Background - also see screenshot: In our first column, we have a date field called “Lifetime Last Payment”, which we manually complete. In our second column, we have a form...

Tiaan_Terblanch · Oct 04, 2022

We have the following columns in our database: Date Joined - regular date Last renewed - regular date Next Renewal - formula (IF({Last Renewed}=BLANK(),BLANK(), DATEADD({Last Renewed},12,“months”)) However, I also need to include my month-to-month me...

Tiaan_Terblanch · Jun 05, 2023

We need the credit amounts to be deducted from the invoice amounts and shown in the sum fields if we group them together.The screenshot shows that the credit amount is added to the invoice amount to give the group the total amount.But in reality, the...

Tiaan_Terblanch · May 31, 2023

Hi Rupert, thank you so much for your response. I tried the formula, but it does not work, so I am adding more information.You will see from the Original Amount column until the Tax Amount column are all formula columns, as I had to add this formula:...

Tiaan_Terblanch · May 29, 2023

Thank you.I need to make sure that most of my input is automated, so in the end, I added a few columns (that I can later hide) to make it a bit easier. I added a formula column dividing my amount by 100, giving me the correct amount I needed.It is lo...

Tiaan_Terblanch · Dec 06, 2022

Thank you so much for your help!

Tiaan_Terblanch · Oct 18, 2022

Thanks Adam, it is working now. I just had to change one last thing; so the formula now reads as: IF( {Lifetime Last Payment} = {Final Lifetime Instalment Date}, “ :white_check_mark: Paid in full”, IF( {Lifetime Next Payment} <=TODAY(), “ :triangula...

User Statistics

User Activity

Deducted credit note amount from invoice amount based on document type

Changing the Decimal space in a currency field

Please help with a formula

Formula that will indicate 2 stages

Formula to indicate 21day prior to renewal

Re: Deducted credit note amount from invoice amount based on document type

Re: Deducted credit note amount from invoice amount based on document type

Re: Changing the Decimal space in a currency field

Re: Please help with a formula

Re: Formula that will indicate 2 stages