# IFTT formula help

Topic Labels: Formulas
Solved
1600 9
cancel
Showing results for
Did you mean:
6 - Interface Innovator

I want to formulate a date if:
under one column the answer is 3-day add 3 days to date
under one column the answer is 2- day add 2 days to date
under one column the answer is 1- day add 1 day to date

I think I begin like this, DATEADD({Proposed Date of W/C},3, ‘days’)

but how do I formulate the if this then that?

1 Solution

Accepted Solutions
14 - Jupiter

Thanks, @Leslie_Miller - that was my bad. I left an erroneous comma in there. Try this:

``````IF(
SEARCH("1", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 1, 'days'),
IF(
SEARCH("2", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 2, 'days'),
IF(
SEARCH("3", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 3, 'days')
)
)
)
``````
9 Replies 9
7 - App Architect
``````IF(
SEARCH("1", {Day Course}),
IF(
SEARCH("2", {Day Course}),
IF(
SEARCH("3", {Day Course}),
BLANK()
)))``````
6 - Interface Innovator

Thanks so much for your response.
not quite right yet, trying different scenarios, I think this might be close
IF(
SEARCH(“1”, {Type of Workshop or Class Offered}}),
IF(
SEARCH(“2”, {Type of Workshop or Class Offered}),
IF(
SEARCH(“3”, {Type of Workshop or Class Offered}{Day Course}),
BLANK()
)))

6 - Interface Innovator

Tried this, still no luck

IF(
SEARCH(“1”, {Type of Workshop or Class Offered}}),
DATEADD {Proposed Date of Workshop or Class} 1, ‘days’),
IF(
SEARCH(“2”, {Type of Workshop or Class Offered}),
DATEADD {Proposed Date of Workshop or Class} 2, ‘days’),
IF(
SEARCH(“3”, {Type of Workshop or Class Offered}),
DATEADD {Proposed Date of Workshop or Class} 3, ‘days’),
BLANK()
)))

14 - Jupiter
``````IF(
SEARCH("1", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 1, 'days'),
IF(
SEARCH("2", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 2, 'days'),
IF(
SEARCH("3", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 3, 'days'),
)
)
)
``````
6 - Interface Innovator

That still did not work, what am I missing

14 - Jupiter

How did it fail? Are you getting an error message in the formula editor? Is it just not returning what you expected? What is the nature of the failure?

6 - Interface Innovator

14 - Jupiter

Thanks, @Leslie_Miller - that was my bad. I left an erroneous comma in there. Try this:

``````IF(
SEARCH("1", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 1, 'days'),
IF(
SEARCH("2", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 2, 'days'),
IF(
SEARCH("3", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 3, 'days')
)
)
)
``````
6 - Interface Innovator

You are a genius THANK YOU!!!