Hi,How should I write the IF function to calculate commission based on A or B ? See below:If Take Rate is filled: Commission = GMV x Take Rate %Otherwise: Commission = GMV - Achat DistributeurThank you
Hi everyone,I need urgent help for something I can't solve. It's like search function in excell.Job to be done:- If EAN of Record 'x' in table 2 = EAN found in a record in table 1 THEN "Handle record" in table 2 = Handle record in table 1.Here is a ...
Hi,Who's gonna help to :- concatenate Row 1+2+3 with a limitation of 3 character per row and a total character of 16 ?I need to create unique reference (in e-commerce) called Variant SKU looking likeModele, Size, Color but as we are limited in number...
Hi Airtable Fans,
I am a fan of Airtable Automation but can’t find out something.
This is my automation goal:
When create a record
IF New Record match X condition (X could be “contain text …” in cell)
Then send an email
I don’t find how to put co...
Hi,
In column A, I listed all weeks number (from 1 to 52)
in column B, I would like to have the correspondant date based on Monday.
ex in 2021
Column WEEK: 52
Column Day = Monday 27th dec.
How to set up this in airtable?
thank you
@Daniel_Orseno Thank you! It's so simple when you get the way to write the formula. Maybe you can help me going to the next level?How to integrate IF condition, but 2 times in the same Formula?In column "A verser €“, I need to say :If({com'distri HT}...
Thank you Andrey.You are right. Actually we will use model/size/color which is unique.I didn't mention it and the screenshot I published was taken before. But indeed, otherwise we would might have duplicate.
We can’t have all data in same Table. Different people. Different client. Different way of calculatin margin etc…
In Excell for exemple, you can make formula like : =sum Table1(A1;A9)+Table2(A1;A9)
is something like this exist in Airtable?
