Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

IFTT formula help

Topic Labels: Formulas
Solved
Jump to Solution
600 9
cancel
Showing results for 
Search instead for 
Did you mean: 

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?
Screenshot 2020-04-06 12.14.37 Screenshot 2020-04-06 12.14.43

1 Solution

Accepted Solutions

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

See Solution in Thread

9 Replies 9
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()
)))Screen Shot 2020-04-06 at 1.34.28 PM

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?

Screen Shot 2020-04-06 at 3.05.03 PM

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