Topic Labels: Formulas
Solved
370 7
cancel
Showing results for
Did you mean:
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},

1 Solution

Accepted Solutions
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

7 Replies 7
9 - Sun

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},

6 - Interface Innovator

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

9 - Sun

What are you expecting to see as a result?

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'

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.

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

9 - Sun

Great, good day to you as well.