Hello :slightly_smiling_face:
New topic new question :
I want to do a DATEDIFF formula really basic).
I did : DATETIME_DIFF({FIN PE},{DATE ENTREE},‘days’)
But it’s really weird it work for some lines and don’t for the others.
No links between the ...
Hello :slightly_smiling_face:
I am a beginner in the creation of Airtable formulas.
Is it possible to create a formula IF(AND(value1,value2,value3) with at least 3 conditions ? I only succeeded it with 2 conditions.
If it’s not possible, do you kno...
There is finally a problem with the simplified formula for “FIN PE”, the number of months included in “DUREE PE (MOIS)” is not added to “FIN PE” and does not double the number of months of “DUREE PE (MOIS)” to be added to “FIN PE” if “PE A RENOUVELER...
The formula is working :ok_hand: and i set the formula configuration but the DATETIMEDIFF formula continues to fail.
DATE ENTREE
FIN PE
DELAIS DE PREVENANCE
I don’t know if all the screens could help to find my error ?
The first date field is enter manually in a european format et the second date field uses in the DATETIMEDIFF formula is the result of these formula :
IF(AND({PERIODE ESSAI ACTIVE}=“OUI”,{PE A RENOUVELLER }=0),DATETIME_FORMAT(DATEADD({DATE ENTREE},{D...
Thank u for the tip, i’ll try it
If the {CONTRAT}=“CDI” i want to appply all the previous formula but IF {CONTRAT}=“CDD” i would like to let the field empty or the best of the best (but I don’t know if it’s possible) would like to let yourself enter ...
