Skip to main content
Solved

IFTT formula help

  • April 6, 2020
  • 9 replies
  • 42 views
L
Forum|alt.badge.img+8

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?

Best answer by Jeremy_Oglesby


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

E
Forum|alt.badge.img+11
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()
)))
L
Forum|alt.badge.img+8
  • Leslie_Miller
  • Author
  • Known Participant
  • April 6, 2020
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()
)))

L
Forum|alt.badge.img+8
  • Leslie_Miller
  • Author
  • Known Participant
  • April 6, 2020

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

J
Forum|alt.badge.img+18

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'),
    )
  )
)
L
Forum|alt.badge.img+8
  • Leslie_Miller
  • Author
  • Known Participant
  • April 6, 2020
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

J
Forum|alt.badge.img+18

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?

L
Forum|alt.badge.img+8
  • Leslie_Miller
  • Author
  • Known Participant
  • April 6, 2020

J
Forum|alt.badge.img+18


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')
    )
  )
)
L
L
Forum|alt.badge.img+8
  • Leslie_Miller
  • Author
  • Known Participant
  • April 6, 2020

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

You are a genius THANK YOU!!!

E
J
Terms & ConditionsAccessibility statement