Skip to main content

 Hello airtable community, I have this following formula but dateadd does not display the operation in the result thank you for your feedback

Franck 

IF(
{Date début package} != '', {Date début package},
IF(
{Date début expl 23} != '', {Date début expl 23},

DATEADD({Date début package},{Nombre jours d'Activité},'days')))



 

It looks like you need to close the quotes.

IF(
{Date début package} != ''", {Date début package},
IF(
{Date début expl 23} != ''", {Date début expl 23},

DATEADD({Date début package},{Nombre jours d'Activité},'days')))

It looks like you need to close the quotes.

IF(
{Date début package} != ''", {Date début package},
IF(
{Date début expl 23} != ''", {Date début expl 23},

DATEADD({Date début package},{Nombre jours d'Activité},'days')))

Hello and thank you for your feedback, this does not work I am attaching a view of the table Thank you and have a good day

https://airtable.com/appYGvpIAdS7m5Hab/shryMIhCEvJUzIFYG


What are you expecting to see as a result?


Good morning and thanks for your help.

Here is my expectation.

If cell "A" is not empty and cell "B" is empty then cell "C" takes the value of cell "A"
and if cell "A" is empty and cell "B" is not empty, then cell "C" takes the value of cell B.
If in cell "C" there is the value of cell "A" then you must add: "dateadd", "Number of days of Activity (from Planning 2024", 'days'

https://airtable.com/appYGvpIAdS7m5Hab/shr6gqkEP8FOIlHU2

while waiting for your back have a good day


Good morning and thanks for your help.

Here is my expectation.

If cell "A" is not empty and cell "B" is empty then cell "C" takes the value of cell "A"
and if cell "A" is empty and cell "B" is not empty, then cell "C" takes the value of cell B.
If in cell "C" there is the value of cell "A" then you must add: "dateadd", "Number of days of Activity (from Planning 2024", 'days'

https://airtable.com/appYGvpIAdS7m5Hab/shr6gqkEP8FOIlHU2

while waiting for your back have a good day


As described:

If in cell "C" there is the value of cell "A" then you must add: "dateadd", "Number of days of Activity (from Planning 2024", 'days'

can never be true since cell "A" is a date and cell "C" is a number.  

 

 


Hello, thank you for your feedback

I got the solution, here is the formula:

IF(AND({A} != '', {B} = ''), DATEADD({A}, {ro}, 'days'), IF(AND({A} = '', {B}! = ''), {B}, IF(AND({A} != '', {B} != ''), {A}, BLANK())))
Good day


Great, good day to you as well.


Reply