Help

Re: IFTT formula help

Solved
Jump to Solution
1132 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Leslie_Miller
6 - Interface Innovator
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?
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
Eric_Petersen
7 - App Architect
7 - App Architect
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?

Leslie_Miller
6 - Interface Innovator
6 - Interface Innovator

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

You are a genius THANK YOU!!!