Help

Re: Formula If and dateadd

Solved
Jump to Solution
393 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Franck_GENTILI1
6 - Interface Innovator
6 - Interface Innovator

 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')))



 

1 Solution

Accepted Solutions
Franck_GENTILI1
6 - Interface Innovator
6 - Interface Innovator

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

See Solution in Thread

7 Replies 7

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?

Franck_GENTILI1
6 - Interface Innovator
6 - Interface Innovator

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.  

 

 

Franck_GENTILI1
6 - Interface Innovator
6 - Interface Innovator

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.