5 - Automation Enthusiast
since ‎Jul 05, 2020
‎Jan 02, 2023

## User Statistics

• 13 Posts
• 1 Solutions
• 3 Kudos given
• 1 Kudos received

## If function (If column A = True, then .., otherwise Column B

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

## Search a record in Table 1, IF found, then copy record in Table 2 Please Help‌🙏‌

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 ...

## Concatenate with limited characters

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...

## How to SEND AN EMAIL based on NEW RECORDS based on a condtion trigger

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...

## Date Formula: how to get a Monday Date based on Week number

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
Kudos from
Kudos given to