IFTT formula help

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?

IF(
 SEARCH("1", {Day Course}),
  DATEADD(Date, 1, 'days'),
IF(
 SEARCH("2", {Day Course}),
  DATEADD(Date, 2, 'days'),
IF(
 SEARCH("3", {Day Course}),
  DATEADD(Date, 3, 'days'),
BLANK()
)))

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}}),
DATEADD(Date, 1, ‘days’),
IF(
SEARCH(“2”, {Type of Workshop or Class Offered}),
DATEADD(Date, 2, ‘days’),
IF(
SEARCH(“3”, {Type of Workshop or Class Offered}{Day Course}),
DATEADD(Date, 3, ‘days’),
BLANK()
)))

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

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

That still did not work, what am I missing

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?

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

You are a genius THANK YOU!!!

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.