This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
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; €...
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...
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...
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...
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...
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:...
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...
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...
