Hi the community.
I have some difficulties with a formla.
I deliver package and i want to calcul the date of the preparation in relation to the delivery date decided by the customer
I want to calcul a date but this is conditionate with the result of a column.
Column A, i have a date : 12/04/2021
Column B, i have two type on result : “GLS” or “Chronopost”
This is what i want is :
If GLS = Date of the column A - 2 day.
With my example the result : 10/04/2021
If Chronopost = Date of the column A - 1 day.
With my example the result : 11/04/2021
I’m guessing your attempt to mimick the above syntax didn’t work? That’s probably because the value in that single-select field is a string, not a number. So, just wrap the desired target in a VALUE() call to coerce it back. Though if these are all dates you’re dealing with, why not save yourself the trouble and reach into Airtable’s many niche formulae for handling dates? Most notably, the DATETIME_DIFF, DATETIME_PARSE, FROMNOW, TONOW, etc., depending on what exactly you’re trying to do.
Thank’s for your email.
I have a date in a column.
If the day mentionned on this column is today, i want to write “YES” to another column. Is there a formula exist for this ? Thank’s a lot,