Skip to main content

Formula If, date

  • September 14, 2021
  • 6 replies
  • 62 views
M
Forum|alt.badge.img+5

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

Sorry for my english.
Could you help me please ?

Thank’s a lot,

Matthieu from www.lagreentouch.fr

6 replies

A
Forum|alt.badge.img+18
  • augmented
  • Inspiring
  • September 14, 2021

Hi Matthieu. Maybe something like this…

IF({Column A},
DATEADD({Column A}, 
        SWITCH({Column B}, 'GLS', -2, 'Chronopost', -1),
        'days')
)

I haven’t tested this suggestion, but good luck!

M
Forum|alt.badge.img+5

Thank’s a lot for your quick answer, it’s working !

To finish my process, i have juste another question :
If the date is TODAY, i want to add a result of a column with single select (for exemple column D).
Can i do that ?

Thank’s a lot for your precious help,

Matthieu

D
Forum|alt.badge.img+17

Thank’s a lot for your quick answer, it’s working !

To finish my process, i have juste another question :
If the date is TODAY, i want to add a result of a column with single select (for exemple column D).
Can i do that ?

Thank’s a lot for your precious help,

Matthieu


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.

A
Forum|alt.badge.img+18
  • augmented
  • Inspiring
  • September 15, 2021

Thank’s a lot for your quick answer, it’s working !

To finish my process, i have juste another question :
If the date is TODAY, i want to add a result of a column with single select (for exemple column D).
Can i do that ?

Thank’s a lot for your precious help,

Matthieu


Can you give us a little more information? When you say, “if the date is TODAY”, do you mean the date in {Column A}? Tell us what the values in the single select are, also.

M
Forum|alt.badge.img+5

Can you give us a little more information? When you say, “if the date is TODAY”, do you mean the date in {Column A}? Tell us what the values in the single select are, also.


Hi,
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,
Matthieu

A
Forum|alt.badge.img+18
  • augmented
  • Inspiring
  • September 15, 2021

Hi,
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,
Matthieu


That sounds like a different question, but pretty easy to do. Replace “date column name” with the name of your column that holds the date.

IF(IS_SAME({date column name}, TODAY(), 'day'), 'YES')

Terms & ConditionsAccessibility statement